when I create and run a query (in the query tab) that selects from or joins several tables, How do I get the table name to display in the results along with the fields names?
Thank you,
~Donavon
How to Display Table Names in query tab??
This is what I would like to do.
select t1.field1, t2.field1
from table1 t1, table2 t2
CURRENT OUTPUT:
field1 field1
blablabla blablabla
blablabla blablabla
blablabla blablabla
OUTPUT IM LOOKING FOR:
t1.field1 t2.field1
blablabla blablabla
blablabla blablabla
blablabla blablabla
select t1.field1, t2.field1
from table1 t1, table2 t2
CURRENT OUTPUT:
field1 field1
blablabla blablabla
blablabla blablabla
blablabla blablabla
OUTPUT IM LOOKING FOR:
t1.field1 t2.field1
blablabla blablabla
blablabla blablabla
blablabla blablabla
Please login to leave a reply, or register at first.