OMID OrderNumber 19 a 20 b
ODID OrderNumberRef ItemName 1 19 x 2 20 y
Select m.OrderFormNo from OrderMaster as m left outer join OrderDetails as n ON m.OMID=n.OMIDFormRef where OrderFormNo='" & cmbOrderNo.SelectedValue.ToString & "'"
select i.ItemName from ItemInfo as i left outer join OrderDetails as o on i.IIID=o.IIIDItemRef where
SELECT m.OrderNumber, n.ItemName FROM OrderMaster m JOIN OrderDetails n ON m.OMID=n.OrderNumberRef WHERE m.OrderNumber = 'a'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)