I have two queries that I would have thought would be the same.
delete from podetail as p1 where p1.gridrowid in (select g1.gridrowid from gridrowmaster as g1 where g1.gridmasterid = 1)
delete from podetail where podetail.gridrowid in (select g1.gridrowid from gridrowmaster as g1 where g1.gridmasterid = 1)
The second one runs, the first gives me an error. Is there a rule about aliasing delete from tables? Thanks