471,073 Members | 1,363 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

MySQL Help me with query!!

I have 4 tables, the info I need from them is beyond my limited SQL
abilities:

EMAIL_TABLE:
email_address, prod_id

DATA TABLE:
prod_id, active

PROD_INV_TABLE:
prod_id, inv_id

INVENTORY_TABLE:
status
inv_id

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
stock.

Thanks for any SQL hints,
-MM

Jul 23 '05 #1
0 846

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by joemyre | last post: by
2 posts views Thread by JDJones | last post: by
reply views Thread by Murphy | last post: by
2 posts views Thread by laredotornado | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.