display the table name

[homer.favenir]

hi,
how do I display multiple TABLE NAME in my script.
e.g.

select 
table1.date,
table1.name,
table1.address
table1.TABLE1'S NAME.

table2.date,
table2.name,
table2.address
table2.TABLE2'S NAME.

table3.date,
table3.name,
table3.address
table3.TABLE3'S NAME.

FROM
table1, table2, table3

how will i display the TABLE'S NAME and unite 3 tables?

thanks