Hi
After adding this line
and b.u_Unique_ID = " & oForm.Items.Item("33").Specific.ToString.Trim) , i am getting this error . b.u_Unique_ID is numeric Data Type.
oDT.ExecuteQuery("SELECT a.Code, a.Name , b.U_Amount as Amount FROM [@TEMP]a left JOIN [@TEMP1]b ON a.Code = b.U_Al_Code and b.u_Unique_ID = " & oForm.Items.Item("33").Specific.ToString.Trim)
Thanks