Re: Table Aliasing in JDBC/Java

From: Tilen Skraba <tiskraba_at_my-deja.com>
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

This message: [ Message body ]
Next message: Rachel Rainey: "Re: How do I know the line number in a stored procedure?"
Previous message: aochss_at_my-deja.com: "Bring Back Only One Record From A Query"
In reply to: Tina Creighton: "Table Aliasing in JDBC/Java"
Next in thread: Rachel Rainey: "Re: How do I know the line number in a stored procedure?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message