Results 1 to 8 of 8
Thread: delete with multiple query
Jan 15, 2005, 07:22 #1
- Join Date
- Sep 2004
- 0 Post(s)
- 0 Thread(s)
delete with multiple query
i have a query to select data in 2 rows in a database. (thanks to darchangel). Now i want to delete the records i found with this query. Is that possible in the same query ?
this is the query i use to select:
SELECT E2.id AS E2id, E2.q AS E2q, E2.a AS E2a FROM survey AS E1 INNER JOIN survey AS E2 ON E1.id = E2.id WHERE E1.a=1 AND E1.q=3
Thanks in advance !