select statement in where clause

[Former Member]

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

[Former Member]

Yes you can, try this

select basic.field1 from basic where basic.employee in (select employee from table_distinct where user='x')

user is a field in table_distinct right?

[Former Member]

Yes,It is right.But the problem is: If I go in Query Panel, sql generated doesn't use the previous syntax,but universe designer uses a inner join...What do I make to generate: {select basic.field1 from basic where basic.employee in (select employee from table_distinct where user='x')} in automatic way???

Sorry for my english

[Former Member]

Hi

furthermore, I would like to know also if data federator support select statment in where clause,is it possible?

bye

[Former Member]

Hi, pocho loco:

what if you create the syntax in a quer filter (yellow object in the universe)?

name: filter_emp

code:

basic.employee in (select employee from table_distinct where user='x')

does the sql change when you use this filter object in the report?

Regards

Erika

[Former Member]

Hi, Erika:

I try it,the code changes!, Select is present in where clause but inner join too,How can it be eliminated?

byee