--- Patrick Aljord <[EMAIL PROTECTED]> wrote:
> 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 > What is the question you want answered? What you wrote can answer some questions but that may not be the actual query you are trying to write. Please describe in words what you are looking for and I (or someone else on the list) will be able to respond with an appropriate query. Shawn Green __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
