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: [EMAIL PROTECTED]

Zope-Dev maillist  -  [EMAIL PROTECTED]
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope )

Reply via email to