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
--- 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
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
--- 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
right syntax.
--
Rhino
- Original Message -
From: "Patrick Aljord" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 25, 2006 8:48 PM
Subject: need help for my jointure
I have a table confs like this:
id int 5 auto_increment primary key;
conf text;
and another table con
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?
th
