-
November 29th, 2010, 06:18 PM
#1
Joining 3 tables - It's an EMERGENCY!!!
So...
I have 3 tables:
TABLE: Sales
Attributes: Sale_id, employee_id, customer_id, date_sale, amount, quantity
TABLE: Products
Attributes: They're too many. Let's consider just product_id, product_name
TABLE: Gets (it's actually a relationship between Sales and Products)
Attributes: sale_id, product_id, qantity
I'm making a query in Sales that shows, among other stuff, the actual NAME of the product that is being sold... I managed to show the employee and customer names, but not the product_name, because I don't have any product_id in Sales table, I don't know how to relate them.
This is what I have so far, showing everything I need, except for the product_name.
select
sales.data_sale as "Date",
a.person_name as "Employee",
b.person_name as "Client",
sales.quantity as "Quantity",
sales.amount as "Total (€)"
from person a, person b, sales
where sales.employee_id = a.person_id and sales.customer_id = b.person_id
Any help please? It's kind of urgent...
-
November 30th, 2010, 04:44 AM
#2
Re: Joining 3 tables - It's an EMERGENCY!!!
You do not mention your database, but you should take a look at the INNER JOIN as that'll do what you need from the look of it.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|