Click here to Skip to main content
14,700,043 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Posted
Updated 10-Nov-12 20:20pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900