Re: Table Aliasing in JDBC/Java
Date: Tue, 23 Nov 1999 21:21:12 GMT
Message-ID: <81f0g3$h2c$1_at_nnrp1.deja.com>
Hi!
What JDBC error did you get?
Is the statement copied from the source?
Be carefull... Your statement is:
SELECT xmen, l1.choice, l2.choice
FROM Book, LookupTable li, LookupTable l2
WHERE book.team = li.id and book.play = l2.id.
Valid aliases in this statement are Book, li an l2. In the statement you refere to the 'l1'...
If that's not the case, send us JDBC/ORA error please.
Tilen
In article <3832EDDD.7251E560_at_navair.navy.mil>,
Tina Creighton <creightonbm_at_navair.navy.mil> wrote:
> 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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 23 1999 - 22:21:12 CET