select
"table 1 - " & table1.project as table_project
from
table 1
union all
select
"table 2 - " & table2.project as table_project
from
table 2
SELECT
"Table 1 - " & [Table 1].project as table_project,
[Table 1].*
FROM
[Table 1]
union all
SELECT
"Table 2 - " & [Table 2].project as table_project,
[Table 2].*
FROM
[Table 2]
union all
SELECT
"Table 3 - " & [Table 3].project as table_project,
[Table 3].*
FROM
[Table 3]
union all
SELECT
"Table 4 - " & [Table 4].project as table_project,
[Table 4].*
FROM
[Table 4]