SQL select 2 rozdielnych tabuliek – MySQL – Fórum – Programujte.com

Zdravim mam 2 tabulky:
novinky:
+----+------+-------+
| id | name | added |
+----+------+-------+

a clanky:
+----+------+-------+-------+
| id | name | content | added |
+----+------+-------+-------+

A potreboval by som ich selectnut a usporiadat podla added aby mi ich hodilo pod seba teda nieco taketo:
+----+------+-------+-------+
| id | name | content | added |
+----+------+-------+-------+
| 5 | novin | null | 4.1.11 |
+----+------+-------+-------+
| 2 | clanok | content | 3.1.11 |
+----+------+-------+-------+
| 5 | clanok | content | 2.1.11 |
+----+------+-------+-------+
| 3 | novin | null | 1.1.11 |

kolem mysql 5 uz by to melo zvladat union..
jen doplnis tu chybejici polozku v novinkach.. neco jako select id, name, null as content, added from ... union select id, name, content, added from ...

dik funguje