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

       table1
----->	id
|	name
|
|       table2
|_____> id 
	address
	zip

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

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