Sorry, I missed the last part of your email.
Try:
SELECT * FROM products p, uses u, prod_uses pu WHERE p.pid=pu.pid AND
u.uid=pu.uid AND uses='use 1';
:-)
----- Original Message -----
From: "Marcel Forget" <lmforget2@stripped>
To: "Mikey" <frak@stripped>; <mysql@stripped>
Sent: Thursday, May 29, 2003 8:17 PM
Subject: Re: SELECT from multiple tables...
> Hi,
>
> It would work something like this:
> SELECT * FROM products p, uses u, prod_uses pu WHERE p.pid=pu.pid AND
> u.uid=pu.uid AND productname='product 1';
>
> Where
>
> products
> pid int(11) PRI (NULL) auto_increment
> productname varchar(25) YES (NULL)
>
> uses
> uid int(11) PRI (NULL) auto_increment
> uses varchar(25) YES (NULL)
>
> prod_uses
> pid int(11) 0
> uid int(11) 0
>
> I hope this works out for you.
>
> Marcel
> ----- Original Message -----
> From: "Mikey" <frak@stripped>
> To: <mysql@stripped>
> Sent: Thursday, May 29, 2003 12:54 PM
> Subject: SELECT from multiple tables...
>
>
> > Hi NG, this is my first visit here, so please be gentle!!!
> >
> > I have a table of products (`prods`), and a separate table of product
uses
> > (`uses`) and the products are linked to their uses by a list
> (`prod_uses`).
> >
> > What I need to be able to do is allow a search of products by their use
> and
> > I am getting a bit stuck on writing the where clause. I know that for a
> > simple join I can use: SELECT * FROM table1, table2, WHERE
> > table1.field=table2.field2 AND table2.field2='value' - but how do I make
a
> > join that will get back all products with a specified application?
> >
> > Many thanks for your help and time...
> > regards,
> >
> > Mikey
> > - In theory, theory and practice should be the same, in practice it
isn't.
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
