On Fri, 20 Apr 2001, Bryan Baszczewski wrote:
<<<< ...I mean that: SELECT tab1.col1, tab2.col1 FROM ... etc ... Does not expose 'tab1.col1' and 'tab2.col1'. In otherwords, it doesn't gracefully handle name clashes. I realize that calling out the variable 'tab1.col1' out of the namespace is a pain, but (hopefully) in the future it would be made easier....>>>>
I havent followed the entire conversation so forgive me if we are on the same page but in different books. Have you tried to alias the column names?
e.g.: SELECT tab1.col1 AS COL1_A, tab2.col1 AS COL1_B FROM etc...
Aliasing works for me. (ZOracleDA). -- _________________________________________________ peter sabaini, mailto: sabaini@niil.at -------------------------------------------------