I would expect "SELECT T.*" to always return all fields from table T.
However this seems not to be the case when using natural join.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table a(aid integer);
sqlite> create table b(bid integer, aid integer);
sqlite> insert into a values (1);
sqlite> insert into b values (2, 1);
sqlite> select * from a natural join b;
aid         bid
----------  ----------
1           2
sqlite> select b.* from a natural join b;

I realize that in the natural join the field "aid" from the first "select *"
query is not considered to belong to either table a or table b, but still in
the second query, shouldn't "select b.*" include all fields from table b?



To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to