Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Keith Medcalf
6 June, 2018 08:56 >To: SQLite mailing list >Subject: Re: [sqlite] Understanding SELECT statement > > > >> On 26 Jun 2018, at 3:42pm, Csányi Pál wrote: >> >>>> INSERT INTO SchoolYearTeachingDays >>>> SELECT aDate FROM TeachingSaturday

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Csányi Pál
Once again, thank you all very much for your help. I understand now this query. R Smith ezt írta (időpont: 2018. jún. 26., K, 17:28): > > > On 2018/06/26 4:42 PM, Csányi Pál wrote: > > > >>> Then I get help and this code: > >>> INSERT INTO SchoolYearTeachingDays > >>>SELECT aDate FROM

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread R Smith
On 2018/06/26 4:42 PM, Csányi Pál wrote: Then I get help and this code: INSERT INTO SchoolYearTeachingDays SELECT aDate FROM TeachingSaturdaysInSchoolYear T WHERE T.aDate NOT IN (SELECT S.aDate FROM SchoolYearTeachingDays S) This says "insert all dates that aren't already present", which

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Simon Slavin
> On 26 Jun 2018, at 3:42pm, Csányi Pál 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 >

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Igor Tandetnik
On 6/26/2018 10:42 AM, Csányi Pál wrote: Igor Tandetnik ezt írta (időpont: 2018. jún. 26., K, 16:10): On 6/26/2018 9:15 AM, Csányi Pál wrote: Then I get help and this code: INSERT INTO SchoolYearTeachingDays SELECT aDate FROM TeachingSaturdaysInSchoolYear T WHERE T.aDate NOT IN (SELECT

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Andy Ling
> > > Then I get help and this code: > > > INSERT INTO SchoolYearTeachingDays > > > SELECT aDate FROM TeachingSaturdaysInSchoolYear T WHERE T.aDate > NOT > > > IN (SELECT S.aDate FROM SchoolYearTeachingDays S) > > > > This says "insert all dates that aren't already present", which of course >

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Csányi Pál
Igor Tandetnik ezt írta (időpont: 2018. jún. 26., K, 16:10): > > On 6/26/2018 9:15 AM, Csányi Pál wrote: > > Then I get help and this code: > > INSERT INTO SchoolYearTeachingDays > > SELECT aDate FROM TeachingSaturdaysInSchoolYear T WHERE T.aDate NOT > > IN (SELECT S.aDate FROM

Re: [sqlite] Understanding SELECT statement

2018-06-26 Thread Igor Tandetnik
On 6/26/2018 9:15 AM, Csányi Pál wrote: I have the 'SchoolYearTeachingDays' table with just one column, in which are dates: CREATE TABLE SchoolYearTeachingDays ( aDate DATE PRIMARY KEY UNIQUE ); I filled it with many dates which are unique. These dates excludes dates for

[sqlite] Understanding SELECT statement

2018-06-26 Thread Csányi Pál
Hi, I have the 'SchoolYearTeachingDays' table with just one column, in which are dates: CREATE TABLE SchoolYearTeachingDays ( aDate DATE PRIMARY KEY UNIQUE ); I filled it with many dates which are unique. These dates excludes dates for Sundays and for Saturdays. I have