RE: [PHP-DB] Finding NoMatches in MySQL
Thanks everyone that was just the ticket :) Off to read up on JOINs now... Thanks again Dave -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED]] Sent: 30 July 2001 08:42 To: Dave Watkinson; PHP-MySQL List Subject: Re: [PHP-DB] Finding NoMatches in MySQL Hi, 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]> To: PHP-MySQL List <[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 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] > > -- 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]
Re: [PHP-DB] Finding NoMatches in MySQL
Hi, 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]> To: PHP-MySQL List <[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 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] > > -- 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-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 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]