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