21-10-21, 01:27 PM
(02-10-21, 01:52 PM)mahmoud_f كتب : السلام عليكم ورحمة الله وبركاتةالسلام عليكم
انا عندى نفس المشكله فى برنامج سوبر ماركة ممكن الحل ليهحل المشكله
كان حل المشكه
"SELECT Operations.operID, Operations.BuyId, Operations.operitem, items.itemprice, items.itemqty, items.itemplace, Operations.buyqty, Operations.buytotalg, Operations.buydiscound, Operations.buydiscound, Operations.buyUnitprice, Operations.buytotalb, Operations.buyearn, Operations.buynotes, Operations.operdate, Operations.opertime, Operations.operuser, Operations.BuyId, items.itemid FROM items , Operations where items.itemName=Operations.operitem AND Operations.BUYID =" & BuyID.Text & "
FROM items , Operations where items.itemName=Operations.operitem AND Operations.BUYID =" & BuyID.Text & "
بدل
FROM Operations LEFT JOIN items ON (Operations.operID = items.itemid) AND (Operations.operitem = items.itemName)