Skip to Content
0
Former Member
Nov 22, 2011 at 03:35 PM

select statement in where clause

1040 Views

Hi

It is possible insert select statement in where clause? I'm using universe design end I want to insert select statement in where clause (a nested subquery).

For example:

select basic.field1

from basic

where basic.employee in{select employee from table_distinct where user='x'}