ay, 26 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 TeachingSat
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 Teachin
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 o
> 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
> FR
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 S
> > > 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
> avo
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 SchoolYearTeachi
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 Su
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 another
9 matches
Mail list logo