> On 8 Jul 2014, at 9:01pm, Paul Sanderson <sandersonforens...@gmail.com> wrote: > > 0, microsoft, mac > 1, oracle, mac > 2, oracle, pc
SELECT t1.recno, t2.name, t3.name FROM t1 JOIN t2 ON t2.a = t1.a JOIN t3 ON t3.b = t1.b ORDER BY t1.recno If you have lots of data on your tables this command will execute far more quickly if t1.recno, t2.a and t3.b are either primary keys or indexes. The way your database is structured, they would all make excellent primary keys. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users