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?
