Hi,
Output in Access 2003:
ID | Description | Quantity | Title | Obj
--- ---------------- --------------------------------------------------
17 |
6 | 253000.00 | |
18 |
7 | 330000.00 | |
19 |
1 | 340000.00 | 8414 | 69327
22 |
2 | 120000.00 | 8414 | 69344
23 |
3 | 615000.00 | 8414 | 69327
24 |
4 | 320000.00 | 8414 | 69327
25 |
5 | 809500.00 | 8414 | 69327
Query :
SELECT TVFundBillDetail.ID ,
TVFundBillDetail.HID ,
TVFundBillDetail.Description ,
TVFundBillDetail.Quantity ,
TVFundBillDetail.Title ,
TVTitle.Name TitleName ,
Obj ,
TVAllObjects.Name ObjName
FROM TVFundBillDetail
LEFT OUTER JOIN TVTitle ON TVFundBillDetail.Title = TVTitle.Code
LEFT OUTER JOIN TVAllObjects ON TVFundBillDetail.Obj = TVAllObjects.Code
Problem: sequence of input row show in description column. when title and obj is null then displace sequence of input row. application is access 2003 and DBMS is SQL Server 2000