Re: Database efficiency question

[denis k]

I kind of understand.

For example:

Product table
-*prod_id
-prod_name
-prod_desc

Customer table
-*cust_id
-pid
-username

SELECT username FROM customer LEFT JOIN products ON
customer.pid=products.prod_id;

Something like this would give me which products each customer has? Am I kind of getting close? I am new to the JOIN scene.