>From page 165 MySQL (New Riders): LEFT JOIN: SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.i1 = t2.i2 WHERE t2.i2 IS NULL
-- david > Ack - sorry - can someone remind me the SQL format for this? > > if you have a linked CLIENTS and INVOICES table... > > ...what's the query to find CLIENTS with NO INVOICES? > > (say 'clientid' is the name of the field in both clients and invoices > table) > > I think it's some kind of join=NULL but I'm stuck. > > > > Thanks! > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php