Hi,
instead of
> select * from test1, test2 where test1.id=test2.id
use
SELECT test1.id AS "test1.id", test1.value, test2.id AS "test2.id",
test2.value FROM test1 , test2 WHERE test1.id = test2.id;
Papp Gyozo
s7461pap@hszk.bme.hu, gerzson17@freemail.hu