MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jason Yates Date:January 24 2002 4:25am
Subject:Inner Join Delete
View as plain text  
Heres an example scenario, say I have two tables

----->	id
|	name
|       table2
|_____> id 

I inner join table1 and table2 on id.  I want to delete all the records in 
table1 which have a zip of '90210'.  I could create a script, run a select 
and loop through each id and delete the records in table1.

-Jason Yates

Inner Join DeleteJason Yates24 Jan
  • Re: Inner Join DeleteJeremy Zawodny25 Jan
    • Re: Inner Join DeleteSinisa Milivojevic25 Jan