|
View previous topic :: View next topic
|
| Author |
Message |
samedesh
Currently Banned
New User
.jpg)
Joined: 22 May 2007
Posts: 46
Location: India
|
|
|
|
Hi All,
I have one sql which is
EXEC SQL
SELECT CUST_NO
FROM POF_LOG
WHERE CONTACT_NO NOT= (input copybook's)CONTACT_NO
END-EXEC.
Now my question is how can I write not in where clause of above sql?  |
|
| Back to top |
|
 |
ashimer
Active Member
Joined: 13 Feb 2004
Posts: 551
Location: Bangalore
|
|
|
|
Do you mean
WHERE CONTACT_NO <> (input copybook's)CONTACT_NO ??? |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
or
WHERE NOT CONTACT_NO = (input copybook's)CONTACT_NO
Try reading the manual. |
|
| Back to top |
|
|
|
|
