rendered paste bodyLet’s say I have a database with 2 tables like this:
First Table name: «Article»
+-----+--------------------+---------------------+
| ref | contenu_titre | date_created |
+-----+--------------------+---------------------+
| 10 | “Titre 1” | 2004-01-02 |
+-----+--------------------+---------------------+
| 11 | “Titre 2” | 2004-02-02 |
+-----+--------------------+---------------------+
| 10 | “Titre 3” | 2004-03-02 |
+-----+--------------------+---------------------+
Second Table name : «Colloque»
+-----+--------------------+---------------------+-------------------+
| ref | contenu_titre | date_created | special_row |
+-----+--------------------+---------------------+-------------------+
| 10 | “Titre 1” | 2004-01-02 | blarg1 |
+-----+--------------------+---------------------+-------------------+
| 11 | “Titre 2” | 2004-02-02 | blarg2 |
+-----+--------------------+---------------------+-------------------+
I want to do a SINGLE query that will give me, as a result :
+-----+--------------------+---------------------+-------------------+
| ref | contenu_titre | date_created | special_row |
+-----+--------------------+---------------------+-------------------+
| 10 | “Titre 1” | 2004-01-02 | |
+-----+--------------------+---------------------+-------------------+
| 11 | “Titre 2” | 2004-02-02 | |
+-----+--------------------+---------------------+-------------------+
| 10 | “Titre 3” | 2004-03-02 | |
+-----+--------------------+---------------------+-------------------+
| 10 | “Titre 1” | 2004-01-02 | blarg1 |
+-----+--------------------+---------------------+-------------------+
| 11 | “Titre 2” | 2004-02-02 | blarg2 |
+-----+--------------------+---------------------+-------------------+
I didn’t ordered it, but I would want those results ordered by date_created as well…
I think I have to use the JOIN function, but I can’t figure out how to make it happend…
Thanks!!