Re: Creating query based on results of a query...

"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...

--
CloudsŪ