Select column from ALL tables
You're looking for UNION and UNION ALL.

select my_column from table1
union all
select my_column from table2
union all
select my_column from ...


But needing to select one column from every table is likely the sign of a significant design error.