[Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

Peter Sabaini sabaini@niil.at
Fri, 20 Apr 2001 17:30:20 +0200 (CEST)


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
-------------------------------------------------