SQL - TechRepublic
General discussion
February 25, 2003 at 09:35 PM
elnur2305

SQL

by elnur2305 . Updated 23 years, 4 months ago

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!

This discussion is locked

All Comments