Re: need help for my jointure

2006-04-27 Thread Patrick Aljord
On 4/26/06, Shawn Green <[EMAIL PROTECTED]> wrote: > > > > --- Patrick Aljord <[EMAIL PROTECTED]> wrote: > > > On 4/26/06, 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_i

Re: need help for my jointure

2006-04-26 Thread Shawn Green
--- Patrick Aljord <[EMAIL PROTECTED]> wrote: > On 4/26/06, 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

Re: need help for my jointure

2006-04-26 Thread Patrick Aljord
On 4/26/06, 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; > ok, sorry all for

Re: need help for my jointure

2006-04-26 Thread Shawn Green
--- 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 > s

Re: need help for my jointure

2006-04-25 Thread Rhino
First of all, I'm going to guess that English is not your first language and tell you that "jointure" is not the word normally to describe the process of combining two tables in a database: the word you want is "joining". Second, there are many kinds of joins and you haven't specified which kin