Hello there!
how do I get the tablenames in an resultset from an query like this:
imagine two tables with columns named id and value
test1:
id | value
------------
1 | hello
2 | goodbye
test2:
id | value
------------
1 | gunter
2 | heinz
select * from test1, test2 where test1.id=test2.id
the problem is:
my resultset looks like this:
id | value | id | value
------------------------
...
but I need:
test1.id | test1.value | test2.id | test2.value
-----------------------------------------------
...
because I dont want to access the fields by index but by name!!!
any suggestions?