Are there any plans to support joins on delete? it can get quite long to
do it the manual way when you have a lot of relational data.
DELETE FROM table
INNER JOIN table2
ON table.id = table2.id
WHERE table2.otherid = 1
This works in standard sql, I realise it may be difficult to implement
just wondering if it was overlooked. The same goes for joins on UPDATE
which don't appear to be supported. I should probably attempt to use
triggers to solve this issue.
Curtis B
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------