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
UNION
SELECT * FROM attach1.table1
etc.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