Creating SQL with alias's

[Marty Phee <mp...@jump-technologies.com>]

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:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>