> On 26 Jun 2018, at 3:42pm, Csányi Pál <[email protected]> wrote:
>
>>> INSERT INTO SchoolYearTeachingDays
>>> SELECT aDate FROM TeachingSaturdaysInSchoolYear T WHERE T.aDate NOT
>>> IN (SELECT S.aDate FROM SchoolYearTeachingDays S)
>
> Just do not understand what are the 'T' and 'S' means out there, after
> FROM clause.
This is from an old stupid syntax for SQL. In more modern SQL we would write
SELECT aDate FROM TeachingSaturdaysInSchoolYear AS T WHERE T.aDate NOT IN
(SELECT S.aDate FROM SchoolYearTeachingDays AS S)
It works for backwards compatibility but the "AS" makes the sense clearer.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
