Sql not in select

[Sambo8]

Hi All,

Oracle and Crystal 8.5

I'm trying to do a crystal report where an id is not in (select blah from blah). I know how to this in SQL but not crystal - I cannot overwrite the SQL Query as I need a parameter that is applied to both the first select and the not in select.

Any ideas?

Cheers

Sam

 

[Turkbear]

Hi,
IIRC, you can add a 'standard' record selection formula and it will be used in addition to the ones set by your Sql Query , so just add the one you need there..





To Paraphrase:"The Help you get is proportional to the Help you give.."