I have a table confs like this: id int 5 auto_increment primary key; conf text;
and another table conf_ip like this: id int 5 auto_increment primary key; conf_id int 5; ==>foreing key of confs ip varchar 150; I would like to select id, conf from confs where ip!='some val'; how can I do this? thanx in advance Pat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]