Thanks, your solution works better in case a student has subscribed a course and has no card. Just add the following SQL statement to the FILE:
INSERT INTO A VALUES(3,'Jack','Bridge'); INSERT INTO A2B VALUES(5,3,3); to prove it. 2012/2/22 Igor Tandetnik <itandet...@mvps.org>: > On 2/22/2012 1:05 PM, Danilo Cicerone wrote: >> >> ....two views. According to the following SQL statement(see below) I'm >> >> going to create a table >> 'A' storing student's name, table 'B' storing courses and table D storing >> cards. >> Furthermore, it creates two pivot tables A2B and A2D to refer courses and >> cards. >> I'd like to query the DB to get that result: >> >> 1|John|Doe|Italian, Spanish|12345 >> 2|Paul|Smith|English, Italian|12345, 13579 > > > select A.*, > (select group_concat(b_course) from A2B join B on (a2b_ref_b = b_id) where > a2b_ref_a=a_id), > (select group_concat(d_card) from A2D join D on (a2d_ref_d = d_id) where > a2d_ref_a=a_id) > from A; > > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
