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

email_address, prod_id

prod_id, active

prod_id, 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

Thanks for any SQL hints,

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.