Maybe what you are looking for is CROSS JOIN, which forces SQLite to keep the order of the tables as presented in the query.