SQLite 3.6.20.
SELECT SUM(Salary - TotalSpent) / 100 FROM (T2 NATURAL JOIN T4) NATURAL JOIN
(T2 NATURAL JOIN T3);
Error: Ambigious column name: Salary
However, if I add two parentheses around "T2 NATURAL JOIN T4", the error goes
away:
SELECT SUM(Salary - TotalSpent) / 100 FROM ((T2 NATURAL JOIN T4)) NATURAL JOIN
(T2 NATURAL JOIN T3);
Why is this so?
_________________________________________________________________
Nya Windows 7 - Hitta en dator som passar dig! Mer information.
http://windows.microsoft.com/shop
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
