Hi,
I'm getting pretty good with PHP. MYSQL on the other hand has always been pretty simple for me, until now.
This Join syntax is not easy for me to understand.
I have 2 tables, tbl1 and tbl2.
tbl1 contains a list of products and information about those products.
tbl2 contains a list of customers who have purchased products from tbl1.
The product name and username are stored in tbl2.
What I need is to get all of the products out of tbl1 that the user has not purchased.
Any suggestions? I'm thinking I need to use Join somehow but I can't figure it out. Maybe My brain needs a rest. I could use another.
Thanks!
