select t01.name, t02.name from users t01, clients t02; or
select cname, uname from client, users; In the forms above, is there a way DBI can discover tables used with the columns? Oracle. Thank you I see java has something that looks interesting. Given an index into the projection, you can retrieve the column and it's table.... I think. java.sql.ResultSetMetaData;