test1 test2
SELECT
test1.NAME,
test2.name1,
test3.name,
test2.name2
FROM
test2,
test1,
(SELECT * FROM test1) AS test3
WHERE
test1.id = test2.name1
AND test2.name2 = test3.id;
test1 test2
SELECT
test1.NAME,
test2.name1,
test3.name,
test2.name2
FROM
test2,
test1,
(SELECT * FROM test1) AS test3
WHERE
test1.id = test2.name1
AND test2.name2 = test3.id;