List:General Discussion« Previous MessageNext Message »
From:Patrick Aljord Date:April 26 2006 12:48am
Subject:need help for my jointure
View as plain text  
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
Thread
need help for my jointurePatrick Aljord26 Apr
  • Re: need help for my jointureRhino26 Apr
  • Re: need help for my jointureShawn Green26 Apr
  • Re: need help for my jointurePatrick Aljord26 Apr
    • Re: need help for my jointureShawn Green26 Apr
      • Re: need help for my jointurePatrick Aljord27 Apr