sqlite sqlselect over many databases

I have several sqlite databases, is it possible to open up more than one, and do a single sql command on them all as one table, they are all the same structure?

You ATTACH databases together… (up to 10 in the current Xojo release), but your statement still has to address each table

SELECT * FROM main.table1
SELECT * FROM attach1.table1

note the 1st is alway MAIN… whatever you “attach” you name yourself

this is a feature in my upcoming Tadpole Database manager

FYI… UNION implies DISTINCT between tables… so you might need to use UNION ALL instead
depends on you situation

and if this is something you do often… Create a VIEW