이거때문에 계속 고민하다가


SELECT * FROM paymentHistory AS t1 LEFT JOIN (SELECT payNumber ,SUM((orderCount - orderDiscount) * menuCost) FROM paymentDetails GROUP BY payNumber) AS t2 ON t1.payNumber = t2.payNumber;

라는 답을 냈는데







깔쌈하게 성공해보렸다ㅋㅋ

아 별것도 아니네ㅋㅋ