Forum Replies Created
-
תנסי את השאילתא הזו
SELECT O1.ORDNAME, O2.ORDNAME
FROM ORDERS O1, ORDERITEMS OI1, ORDERS O2
WHERE O1.ORD = OI1.ORD
AND O1.CURDATE >= SQL.DATE8 – 7*24:00
AND O2.CURDATE >= SQL.DATE8 – 7*24:00
AND O1.CUST = O2.CUST
AND EXISTS (SELECT 1 FROM ORDERITEMS OI2
WHERE OI2.PART = OI1.PART
AND OI2.QUANT = OI1.QUANT)
AND O1.CUST > 0
AND OI1.ORDI > 0
FORMAT;
