I have a table 'PersonProducts' which contains the Products that can be sold by each sales persons.
The structure of the table is like this...
prnprod_id int primary Key
prnprod_prn int (references prn_id in Person table )
prnprod_prod int (references to prod_id in Products table )
I want to get the list of products (prnprod_prod) that are common to all the persons (prnprod_prn).
Can you send me the query which performs this...