csanyipal wrote > csanyipal wrote > 2017-09-01|F|1-2|5|b > 2017-09-01|F|1-2|7|c > 2017-09-04|M|1-2|7|b > 2017-09-04|M|1-2|5|a > 2017-09-05|Tu|1-2|8|c > 2017-09-05|Tu|1-2|8|b > 2017-09-06|W|1-2|8|a > 2017-09-06|W|1-2|7|a > 2017-09-07|Th|1-2|6|a > 2017-09-07|Th|1-2|5|c > 2017-09-08|F|3-4|5|b > 2017-09-08|F|3-4|7|c > 2017-09-11|M|3-4|7|b > 2017-09-11|M|3-4|5|a > 2017-09-12|Tu|3-4|8|c > 2017-09-12|Tu|3-4|8|b > 2017-09-13|W|3-4|8|a > 2017-09-13|W|3-4|7|a > 2017-09-14|Th|3-4|6|a > 2017-09-14|Th|3-4|5|c > 2017-09-15|F|5-6|5|b > 2017-09-15|F|5-6|7|c > 2017-09-18|M|5-6|7|b > 2017-09-18|M|5-6|5|a > 2017-09-19|Tu|5-6|8|c > 2017-09-19|Tu|5-6|8|b > 2017-09-20|W|5-6|8|a > 2017-09-20|W|5-6|7|a > 2017-09-21|Th|5-6|6|a > 2017-09-21|Th|5-6|5|c > > Can this output be achieved with a SELECT > <http://www.sqlite.org/lang_select.html> query?
I think I must to create one more CTE called SchoolWeeks and must modify the LBs table like this: LBs(SchoolWeek,lessonBlock) AS ( VALUES (1,'1-2'), (2,'3-4')/*, (3,'5-6'), (4,'7-8'),(5,'9-10'), (6,'11-12'), (7,'13-14'), (8,'15-16'), (9,'17-18'), (10,'19-20'), (11,'21-22'), (12,'23-24'), (13,'25-26'), (14,'27-28'), (15,'29-30'), (16,'31-32'), (17,'33-34'), (18,'35-36'), (19,'37-38'), (20,'39-40'), (21,'41-42'), (22,'43-44'), (23,'45-46'), (24,'47-48'), (25,'49-50'), (26,'51-52'), (27,'53-54'), (28,'55-56'), (29,'57-58'), (30,'59-60'), (31,'61-62'), (32,'63-64'), (33,'65-66'), (34,'67-68'), (35,'69-70'), (36,'71-72') */ SWs(SchoolWeek) AS VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36) so I can JOIN these in a proper way. Right? ----- Best, Pál -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users