Re: find non-matching rows

2002-04-10 Thread Harry Roolaart
Sorry, new member didn't know whether I should hit reply or send as new message. SELECT cscflash_mb.email FROM cscflash_mb LEFT JOIN csc_teammembers USING (email) WHERE csc_teammembers.tes_email IS NULL; MySQL said: Unknown column 'csc_teammembers.email' in 'on clause' What ON clause? Note: in

find non-matching rows

2002-04-10 Thread Harry Roolaart
Hi, If I have two mysql tables with two columns for email addresses respectively: csc_teammembers.tes_email AND cscflash_mb.email Now, what I want to do is only query those email addresses in cscflash_mb that DO NOT have a match in the csc-teammembers dbtable. Can I just do a select statement