Skip to Content
0
Former Member
Nov 07, 2012 at 07:43 AM

Query

24 Views

Hi

This query is working fine , i want further addition to it to get the current empid . I have field in second table to link with OHEM

oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT a.Code, a.Name , b.U_Amount FROM [@TEMP1]a left JOIN [@TEMP1]b ON a.Code = b.Code")

Thanks