On Thu, 1 Jul 2004, DOCloudsNOT_at_hardwareSPAM-spot.com wrote:
>
> "Sybrand Bakker" <sybrandb_at_hccnet.nl> schreef in bericht
> news:0cb6e0tg2f3g65a1ut0inpcdt877jld42s_at_4ax.com...
>> On Wed, 30 Jun 2004 17:08:26 +0200, "CloudsŪ"
>> <DOCloudsNOT_at_hardwareSPAM-spot.com> wrote:
>>
>> >I guess this is not possible with plain SQL....
>>
>>
>> It is definitely possible with plain sql.
>>
>> select * from
>> (<your original select>)
>> where etc.
>
> Thank's for your reaction, but I think you did not realise what
> I want, or I don't get your solution...
>
> I'd like to do something like this:
>
> select * from table1 where table1.value (select operator from
> table2) (select value from table2)
>
> So the problem is getting an operator from table2 and use it in
> the query on table1. Table2.operator is in the form of = , > ,
> != etc...
PLSQL and execute immediate.
--
Galen Boyer
Received on Thu Jul 01 2004 - 08:36:12 CDT
