Delete from a inner join b on a.id = b.id inner join c on a.id = c.id inner join d on a.id = d.id inner join e on d.id2 = e.id2 inner join f on e.id3 = f.id3 where b.type = '1' and d.number > 1000 and f.typevalue = 'x'
set cascade property ............... So that any reference in table also deleted
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)