It may seem simple, but I need it badly.
How can I get records of two tables in order (with SQL). I can join tables together, but can’t do this. Example:
Table1
———————-
| Bill_Date | Remark |
———————-
| 01.02.03 | tab1_1 |
| 03.02.03 | tab1_2 |
———————-
Table2
———————-
| Bill_Date | Remark |
———————-
| 02.02.03 | tab2_1 |
| 04.02.03 | tab2_2 |
———————-
After joining
———————-
| Bill_Date | Remark |
———————-
| 01.02.03 | tab1_1 |
| 02.02.03 | tab2_1 |
| 03.02.03 | tab1_2 |
| 04.02.03 | tab2_2 |
———————-
records must be ordered by soe criteria, for example date.
Thanks alot in advance!