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
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 [EMAIL PROTECTED]
To: Mikey [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, May 29
Try:
select name, birthday from atable where month(birthday)=month(now()) and
dayofmonth(birthday)=dayofmonth(now());
Marcel
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:20 PM
Subject: Select name, email where