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 the
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
employers.uid.
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!
Dave
--
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]