Re: [SQL] subselect return in where clause

Michael Hostbaek <[EMAIL PROTECTED]> writes: > select some_stuff, more_stuff, > (select other_stuff from other_table where other_table.stuff ilike > stuff.match) as other_stuff from stuff where other_stuff = 'hello' The above is nonsensical: WHERE cannot refer to values computed in the SELECT lis

[SQL] subselect return in where clause

Group, Is it possible to use a subselect result in a where statement ? If so, how ? Fx. select some_stuff, more_stuff, (select other_stuff from other_table where other_table.stuff ilike stuff.match) as other_stuff from stuff where other_stuff = 'hello' thanks. -- Best Regards, Michael