Vyber poslednych z 2 tabuliek – MySQL – Fórum – Programujte.com

Ahojte,
potrebujem vybrat z MySQL databazy posledne zaznamy z 2 tabuliek, pricom maju niektore polia rovnako pomenovane.
Cize nieco:

SELECT * FROM tbl1,tbl2 ORDER BY id DESC;

Nikto? Pls pomozte...
Mozno sa pokusim upresnit:

tbl 1:

|id|	meno	|heslo|

|1|	jano	|0000|



tbl2

|id|	email		|heslo

|1|	bl@bla.sk	|1111

pro prvni problem zkus tohle:

SELECT * FROM tbl1 ORDER BY id DESC LIMIT 0,1 UNION SELECT * FROM tbl2 ORDER BY id DESC LIMIT 0,1

SELECT * FROM (SELECT * FROM tbl1 UNION SELECT  * FROM tbl2) AS finaltbl ORDER BY id

SELECT * FROM (SELECT * FROM tbl1) AS tbl_1, (SELECT * FROM tbl2) AS tbl_2 ORDER BY id

SELECT * FROM tbl1 ORDER BY id DESC LIMIT 0,1 UNION SELECT * FROM tbl2 ORDER BY id DESC LIMIT 0,1

ERROR 1221 (HY000): Incorrect usage of UNION and ORDER BY

SELECT * FROM (SELECT * FROM tbl1 UNION SELECT  * FROM tbl2) AS finaltbl ORDER BY id

ERROR 1222 (21000): The used SELECT statements have a different number of columns

SELECT * FROM (SELECT * FROM tbl1) AS tbl_1, (SELECT * FROM tbl2) AS tbl_2 ORDER BY id

ERROR 1052 (23000): Column 'id' in order clause is ambiguous

Na to omezeni jsem zapomnel.
Tedka me tak napada, ze by mohlo fungovat toto:

SELECT * FROM tbl1, tbl2 ORDER BY tbl1.id, tbl2.id