Java & JDBC Table Aliasing...

I've been trying to use table aliasing to use one table to lookup several values.
for example:

select xmen, l1.choice, l2.choice from Book, LookupTable li, LookupTable l2
where book.team = li.id and book.play = l2.id.

I get an error in JDBC.
Anywone know how Received on Wed Nov 17 1999 - 12:01:37 CST