| Welcome to WebmasterWorld Guest from 184.108.40.206 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|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)|
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)|
Yup- LEFT OUTER JOIN is your friend!
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)|
awesome! Thanks so much!
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved