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'}