I think this query should do the job

SELECT jobs.uid FROM jobs LEFT JOIN employers ON jobs.id1 = employers.uid
WHERE employers.uid is Null

Dobromir Velev

-----Original Message-----
From: Dave Watkinson <[EMAIL PROTECTED]>
Date: Monday, July 30, 2001 12:56 AM
Subject: [PHP-DB] Finding NoMatches in MySQL

>Hi all
>During the process of importing a lot of Oracle data into MySQL, I have two
>tables that are giving me a bit of a headache. One is a list of jobs and
>other is a list of employers. There's now a unique id for each table, and
>the job table also has a column called id1, which *should* correspond to
>With me so far?
>Well, the problem is that there were loads of duplications in the employers
>table, and after deleting the duplicates some of the jobs.id1 records now
>point to non-existing records.
>How do I do a query that does something like this...
>select jobs.uid from jobs where jobs.id1 not in employers.uid
>many thanks in advance!
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to