title: Using LinqDataSource with SELECT statement
body: <p>I am using LingDataSource, and I know I can’t use join query. How/Where can I put the below SELECT STATEMENT inside the gridivew to display the DBO.TOTALHOURSLU.DISPLAY instead of the DBO.LEAVEREQUEST.TOTALHOURSEFFECT?</p>
  
  <pre><code>SELECT     dbo.LeaveRequest.TotalHoursEffect, dbo.TotalHourslu.Minutes, dbo.TotalHourslu.Display
  FROM         dbo.LeaveRequest INNER JOIN
                        dbo.TotalHourslu ON dbo.LeaveRequest.TotalHoursEffect = dbo.TotalHourslu.Minutes
  </code></pre>