Hi
It is giving me error "Invalid Query Tree [300-33] after i added this line LEFT JOIN OHEM c ON b.U_Unique_ID = m_id
If ((BusinessObjectInfo.FormTypeEx = "60100" And BusinessObjectInfo.EventType = SAPbouiCOM.BoEventTypes.et_FORM_DATA_LOAD) And (BusinessObjectInfo.BeforeAction = False)) Then
Dim oForm As SAPbouiCOM.Form = Me.SBO_Application.Forms.Item(BusinessObjectInfo.FormUID)
Dim oGrid As SAPbouiCOM.Grid = oForm.Items.Item("MyGrid").Specific
Dim oDT As SAPbouiCOM.DataTable = oGrid.DataTable
m_id = oForm.Items.Item("33").Specific.value.ToString()
oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT a.Code, a.Name , b.U_Amount,b.U_Unique_ID as Amount FROM [@TEMP]a left JOIN [@Temp1]b ON a.Code = b.U_Al_Code where b.U_Unique_ID = m_id")
endif
Thanks