SELECT     TOP (100) PERCENT dbo.SODISPATCH.SODISPATCHID, dbo.CUSTOMER.CUSTOMERNAME, dbo.CUSTOMER.ADDRESS1, dbo.CUSTOMER.ADDRESS2, 
                      dbo.CUSTOMER.ADDRESS3, dbo.CUSTOMER.PINCODE, dbo.CUSTOMER.PHONENO, dbo.CUSTOMER.COUNTRY, dbo.CUSTOMER.FAXNO, 
                      dbo.CUSTOMER.EMAIL
FROM         dbo.CUSTOMER INNER JOIN
                      dbo.SODISPATCH ON dbo.CUSTOMER.CUSTOMERID = dbo.SODISPATCH.CUSTOMERID INNER JOIN
                      dbo.SALESORDER ON dbo.CUSTOMER.CUSTOMERID = dbo.SALESORDER.CUSTOMERID
ORDER BY dbo.SODISPATCH.SODISPATCHID