what is wrong with delete/join syntax? 1

[pandatime]

Hi,

Not sure why it doesn't like this:

delete from map a
join
	(
	select pk from map m
	join dup d on (m.id = d.id)
	where isnumeric(m.text) = 0
	) b
on (a.pk = b.pk)

Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'a'.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near 'b'.

 

[Axworthy]

Try this;

delete from map
  from map a
  join dup d on (a.id = d.id)
  where isnumeric(a.text) = 0

 

[gmmastros]

When you have multiple tables involved in a delete, you need to identify which table to delete from.

Try this:

delete [!]a[/!] from map a
join
    (
    select pk from map m
    join dup d on (m.id = d.id)
    where isnumeric(m.text) = 0
    ) b
on (a.pk = b.pk)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom