View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:52 AM
Paul Lautman
 
Posts: n/a
Default DELETE where NOT EXISTS

I can successfully perform the query

SELECT * FROM `mos_availability` a WHERE NOT EXISTS (

SELECT *
FROM mos_users b
WHERE a.user = b.id)
But

DELETE FROM `mos_availability` a WHERE NOT EXISTS (

SELECT *
FROM mos_users b
WHERE a.user = b.id)

Says that I have an SQL syntax error.

Can anyone spot what it is for me?

TIA
Regards
Paul


Reply With Quote