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 !