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