Seamus Abshere writes:
> Should there be a warning for the first query that you reference "tracks" in
> a subquery but don't use any columns from it?
Unfortunately, outer references in subqueries are perfectly legal per SQL
standard, and also often essential.
If we were to invent a "SET trainin
I almost got bit by this today:
=> select email from subscribed where email not in (select email from tracks);
email
---
(0 rows)
=> select email from subscribed where email not in (select tracks.email from
tracks);
ERROR: column tracks.email does not exist
LINE 1: ... email from subscribe
