how to do a "... where key not in (select ...)" ?

[mberni]

Hi out there!

i just wondered if there is a way within crystal (V9 dev) to do a query against some table where key is NOT in some other table.

in sql i would do something like that (simplified):

select a.key from table a
where key is not in (select b.key from table b)

i could simply create a view which delivers that, but i don't like to create a view just for that report...

so i did a outer join (left join) and filtered the NULL-values. everything's fine.

i just wonder if there is another way to do this, i.e within crystal.

any suggestions?

 

[lbass]

You could use a command to do this. Go to database->database expert->add command and enter your query there.

-LB