Why does one query run and the other not run?

Databases
1

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

2

When using aliases the table(s) to delete from needs to be defined.

1 Like
3

ok, thanks

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.