SELECT COURSE.Course, COURSE.CourseDate, CUSTOMER.CustomerName, CUSTOMER.Phone, COURSE.Fee, ENROLLMENT.AmountPaid
FROM CUSTOMER INNER JOIN ((COURSE INNER JOIN ENROLLMENT ON COURSE.CourseNumber = ENROLLMENT.CourseNumber) ON CUSTOMER.CustomerNumber = ENROLLMENT.CustomerNumber
WHERE (((COURSE.Course)="Adv Pastels") AND ((COURSE.CourseDate)="2006-10-01)));

 

 

입력할려고 하는데 자꾸 조인 오류가 난다고 해서요..ㅠㅠㅠ

왜 오류인지 계속 수정해도 안되던데...

뭐가 문젠지 알려주실분 계신가요?ㅠㅠㅠㅠㅠㅠㅠ부탁드려요ㅜㅜㅜㅜ