On 4 Feb 2017, at 3:31pm, Nigel Verity <nigelver...@hotmail.com> wrote:
> My question regards the SQL I've used to populate the grid. I'm no SQL guru, > so joining all the tables together in a single view using multiple nested > left joins is probably beyond my comfort level. You don’t have to nest the joins. You can put many JOINs in the same SELECT: CREATE VIEW AllPhases AS SELECT *, p1.a, p2.b, p3.c FROM Products JOIN p1 ON p1.productID = Products.id JOIN p2 ON p2.productID = Products.id JOIN p3 ON p3.productID = Products.id With only 5000 products you probably won’t notice any difference in performance, but the above syntax will give you simpler code and if you lay it out as above it will be easier for other people to understand. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users