I know this topic came up recently:

select t1.* from t1 ty;

gives a join between two instances of t1, rather than the expected
query rejection (the table in the from clause should be referred to as
"ty").

There was talk of disallowing:

select t1.*;

which seems to be a bit harsh, since it is a *nice* shorthand. How
about disallowing it if there is a FROM clause specified? That is,

select t1.*;

is allowed, but

select t1.* from t2;

is not? Pretty sure I can do this. Comments?

                     - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Sun, 06 Feb 2000 16:55:36 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Implicit RTEs