SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1(id INTEGER PRIMARY KEY, attachment TEXT);
CREATE TABLE table2(id INTEGER PRIMARY KEY, attachment TEXT);
CREATE TABLE table3(id INTEGER PRIMARY KEY, col TEXT);
CREATE TABLE table4(id INTEGER PRIMARY KEY, attachment TEXT);
SELECT GROUP_CONCAT('SELECT ' || pti.name || ' FROM ' || sm.name, ' UNION ALL ') sql
FROM sqlite_master sm CROSS JOIN pragma_table_info(sm.name) pti
WHERE sm.type = 'table' AND pti.name = 'attachment';


sql


SELECT attachment FROM table1 UNION ALL SELECT attachment FROM table2 UNION ALL SELECT attachment FROM table4