Table Aliasing in JDBC/Java

From: Tina Creighton <creightonbm_at_navair.navy.mil>
Date: Wed, 17 Nov 1999 10:03:09 -0800
Message-ID: <3832EDDD.7251E560_at_navair.navy.mil>

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 - 19:03:09 CET