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