I am trying to sort using combinition of 2 fields from different tables.
Let me explain:
TABLE 1
Customers - CustomerID, RescheduleDateTime, TimeZoneID
TABLE 2
TimeZones - TimeZoneID, TimeZoneName, ServerTime difference
How could I create a sortexpression as follows :
SELECT CustomerID FROM Customers
INNER JOIN TimeZones ON [Customers].TimeZoneID = [TimeZones].TimeZoneID
ORDER BY DATEADD(mi,[TimeZones].ServerTime ,[Customers].RescheduleDateTime)
I am using 2 classes scenario
using customers.GetMulti(filter,0,sortBy)
TIA
Swanand
