display the table name

homer.favenir · #1 (**permalink**) 04-15-08, 04:15

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

Code:

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

healdem · #2 (**permalink**) 04-15-08, 05:10

select .... "mytablenamer" as tablename from .......;
but why would you want to?

homer.favenir · #3 (**permalink**) 04-15-08, 06:16

thanks!

i like to monitor what process(table) my employee is doing for the whole day.

e.g.

empname / process
name1 / key entry
name1 / coding
name 2 / scanning
name2 / qc
name3 / key entry
name3 / scanning

all process is table, they input their work in tables. and they change process everyday.

thanks