Do you have a question? Post it now! No Registration Necessary. Now with pictures!
July 13, 2005, 1:58 pm
rate this thread
EMAIL_TABLE: I want to get a list of email_addresses and prod_ids
DATA_TABLE: check that the prod_ids are active = y
PROD_INV_TABLE: and check what the prod_id's inv_id is,
INVENTORY_TABLE: and list the set where the number of rows matching the
prod_id's inv_id, having status = 'available' is greater than 1
The final set should only show the email_address, prod_id (where the
above filter has been applied).
As you might guess, the above it to notify when an item is back in
Thanks for any SQL hints,
- » having mySQL find only orders with multiple rows in another table
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum