SQLite Forum

request on 5 tables
Login
It is possible to stack JOINs into one SELECT statement. You do realize that by doing INNER JOINs you are asking only for recorda that exist in ALL the tables, so anyone that only exists in 4 or less out of the 5 tables won't get returned?