用连接主要你要说明你四张表的关系主建外建
select A.*,B.*,C.*,D.* from A
INNER join B on A.id=B.id
INNER join C on B.id=C.id
INNER join D on C.id=D.id
select A.*,B.*,C.*,D.* from A
INNER join B on A.id=B.id
INNER join C on B.id=C.id
INNER join D on C.id=D.id
另外,CMP可建立在VIEW上。
FROM Person AS p, IN(p.student.coursesEnrolledIn) AS c
WHERE p = ?1
能否对你的代码做一下解释!!!