Creating SQL with alias's

[Marty Phee]

Query:
select  table1.col1, 
        table1.col2, 
        a.col2, 
        b.col2
from    table1,
        table2 a,
        table2 b
where   table1.col1 = a.col1
and     table1.col2 = b.col1;

I see I can use addAlias to add an alias for a table, but how do I add
the columns of the foreign key table.  Do I just need to do it through
some string parsing?

Thanks,

Marty



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>