On 22 February 2012 18:05, Danilo Cicerone <cyds...@gmail.com> 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 > . . . > so could you suggest an SQL solution? > > Thanks in advance, Danilo >
SELECT * FROM aTest NATURAL JOIN dTest; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
