Posted by Malcolm Dew-Jones on 11/04/17 11:17

p cooper (pdconetwofour_numbers_@yahoo.co.uk) wrote:
: Im not at work at the moment .....

: gentoo linux server with probably 4.0.22

: I suppose its possibe to rewrite it with a JOIN ( or perhaps a NOT JOIN ?)?

: clues please.

left join the tables on the shared column, and look for rows where the
second table has null in the joined column. Those are the rows where the
right table doesn't exist.

--

This space not for rent.

[Back to original message]