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?

Thanks!