Re: Delete in one table with information from another table

2001-06-28 Thread Sinisa Milivojevic
Johan Nilsson writes: > Is there any way I can delete in one table with information from another > table without doing as the following example? > > SELECT column_name FROM table_1 > "result = 1,2,3" > DELETE FROM table_2 WHERE column_name = 1 > DELETE FROM table_2

Delete in one table with information from another table

2001-06-27 Thread Johan Nilsson
Is there any way I can delete in one table with information from another table without doing as the following example? SELECT column_name FROM table_1 "result = 1,2,3" DELETE FROM table_2 WHERE column_name = 1 DELETE FROM table_2 WHERE column_name = 2 DELETE FROM table_2 WHERE colum