mysql joining three specific tables
- by sam lim
Here what i would like to pull date from this three table.
Table users i have three columns
uid, username , data(text)
Table users_order i have three columns
uid, orders_id , users_email
Table order_products i have three columns
orders_id, product_id, product_name
I would like to use product_id as the ref/search to pull the user info from those three tables.
If product_id = 5
The query will display
uid; username; users_email; orders_id; product_name; data (text)
how would i right the sql query for this situation.
Thanks,