quick sql help

[Robert Nichols]

I have a cursor that has two fields (from different tables) that  
share the same name.

Is the strategy here to give one (or both) an alias name in my select  
statement? That way, when getting values from the cursor I can use  
one or both alias names, which are not duplicated.

If so, what is the sql syntax to create the alias name?

Is there another strategy?

Thanks a million.