how to select the product name that all the customers have bought in sql ??

Question

I have two tables one for products and one for customers and the relation between them is many to many I want to select the product name that all the customer have bought
how to do that query ???

the tables are

__________
Customers
__________

cusID
cusName


__________
Products
__________
ProID
ProName
cusID


two records for the customer

________________________
cusID | cusName |
________________________
1 | name1 |
2 | name2 |
________________________

records for the Products

_________________________________
ProID | ProName | cusID |
_________________________________
1 | pro1 | 1 |
2 | pro1 | 2 |
3 | pro2 | 1 |
_________________________________

I want the query that selects the product name that all the customers have bought so it will be pro1

Answer 1

Ok assuming this table structure:

Products
========
ProductID
ProductName
ProductDescription

Customers
==========
CustomerID
CustomerName


What exactly is the relationship which the two tables have in common?

Do you have like an Invoice table or something where the Customer and Product are linked?

Answer 2

Select * from customers a left outer join products b where a.cusid = b.cusid

Note that if the unique index on products is the productID, every product will be associated with no more than one customer. If this is the case, the value in products.cusid likely reflects the last customer who purchased the product - not all customers that have purchased the product.

Answer 3

ZOplex is right. You have to specify the relationship between two tables and pl brief the columns detail and if you have any transaction table.

Answer 4

NO manches!!!!!!!! If you give me an example of 2 records for each table I can get the sql query for you, now
[e-mail]

Answer 5

You need to add ORDER BY TIMESTAMP DESCENDING. This will bring in the products most recent first. There are loads of sites that detail how to do this.

Answer 6

You're lucky man cos this is my job ....and i don't tokng about my self but i will answer you about what you really want ...
Table 1
--------------------
Products
idproduct
iduser
namep
type
cost
etc..
--------------------
Table2
-------------------
Customersinfo
iduser
name
age
etc
-------------------

$sql="SELECT * FROM `Products`,`Customersinfo` WHERE Products.iduser = customersinfo.iduser ";
---------------------------------

This all what you Need to do And Give me My Point .