Question about sorting in VB + SQL query

Question about sorting in VB + SQL query

Hi

First of all you don’t have mentioned query in detail or just idea of query. I think the scenario you are discussing is about the making of query when you want to sort out the record in term of ascending or descending order. 

sql = " SELECT     VDetail. VoucherID, VDetail. VoucherDate, VDetail .VoucherNo, "

sql = sql & " VDetail. AccountNo, Accounts. AccountTitle, Accounts. AccountType,

sql = sql & " FROM         VDetail LEFT OUTER JOIN"

sql = sql & " Accounts ON VDetail. AccountNo = Accounts. AccountNo "

sql = sql & " ORDER BY Accounts. AccountType DESC, VDetail. AccountNo"

In the given query you can see that I have selected Voucher ID, Voucher Date, Voucher No, and Account No from the VDetail table and Account Title, Account Type from the table of Accounts. Then I use LEFT OUTER JOIN between both tables as a connection. After that I make condition on both tables that the query will select the records where Account No of VDetail is equal to the Account No of Accounts. And in last I use ORDER BY condition to sort the records. Here I want to show the records in descending order in terms of Account Type that is why I use DESC after mentioning Account type field. Keep in mind two things:

1: all records are by default in ascending order when you use ORDER BY condition. For descending order you need to mention DESC after the required field.

2: the filed you will mention before DESC will only be sort out in descending order. Other fields will not be affected.