[castor-dev] How can I use NOT IN -- keyword

[Aditya Akella]

Hi All,

How can I use NOT IN -- keyword with the SQL statement in Castor. I was able
to make it work with CALL SQL as it is a SQL statement.

Here is a example CALL SQL Statement.

CALL SQL SELECT * from CPT_CODE where code like '%A' and CPT_ID NOT IN
(SELECT CPT_ID FROM PROVIDER_CPT_PREFS WHERE PL_LOCATION_ID=1) AS
CptCodeJdo;

I want to do something like this

SELECT p FROM CptCodeJdo p where p.cptCode LIKE $1 and p.cptId NOT IN
(...........);

I'm not able to use the NOT IN like this. Any code snippet would be very
helpful.

Thanks,
Aditya

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev