Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL parameter with join?

SQL parameter with join?

From: gg200492 <gg200492_at_ratp.fr>
Date: Wed, 11 Apr 2001 16:27:40 +0100
Message-ID: <3AD477EC.B240F21E@ratp.fr>

Can I have a parameter in the where clause when i have already a join on this field?
how to do else?it doesn't work quickly

ex:

select a.f1,b.f2
from a,b
where a.f1=b.f1
and a.f1 like &parameter1; Received on Wed Apr 11 2001 - 10:27:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US