Hacker News new | ask | show | jobs
by nice2meetu 1951 days ago
CROSS JOIN in sqlite3 is used to force the order of the tables in the join. Note the query has a WHERE condition so is the same as an INNER JOIN

https://www.sqlite.org/optoverview.html#manual_control_of_qu...