Instead of <> use !=

Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com


-----Original Message-----
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] query


Hi to all,
can anyone please tell me what I'm doing wrong in this query?

This one doesn't work when I use <> operator
INSERT INTO record_status(rec_id) select 150bk.ID from 150bk
WHERE PHY_ST<>'IN' Or PHY_ST<>'OR' Or PHY_ST<>'PA' Or PHY_ST<>'IA' Or
PHY_ST<>'MN' Or PHY_ST<>'CO' Or PHY_ST<>'ME' Or PHY_ST<>'TN' Or
PHY_ST<>'GA';

but this one works with = operator
INSERT INTO record_status(rec_id) select 150bk.ID from 150bk
WHERE PHY_ST='IN' Or PHY_ST='OR' Or PHY_ST='PA' Or PHY_ST='IA' Or
PHY_ST='MN' Or PHY_ST='CO' Or PHY_ST='ME' Or PHY_ST='TN' Or PHY_ST='GA';

Thanks in advanced

Nato


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to