Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

can I do a join that shows what is 'not' in the other table?

mysql, query, join



7:12 pm on Nov 24, 2010 (gmt 0)

5+ Year Member

I have two tables connected by 'pid'.
When setting a product up, there is an option to set a tax table. If none is set, the table 'tax' does not get an entry.

Can I use a join to show all pids in 'products' that are not in 'tax', or do I have to build a PHP routine to sift this out?



7:31 pm on Nov 24, 2010 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month

Yup- LEFT OUTER JOIN is your friend!

SELECT Table1.pid
FROM Table1 LEFT OUTER JOIN Table2 ON Table1.pid=Table2.pid
WHERE Table2.tax IS NULL


1:03 am on Nov 25, 2010 (gmt 0)

5+ Year Member

awesome! Thanks so much!

Featured Threads

Hot Threads This Week

Hot Threads This Month