兩個(gè)對象:
學(xué)生表:Student
課程表:Course
兩者的關(guān)系是多對多,當查詢(xún)Student對象,并以Course對象作為條件時(shí)的sql語(yǔ)句寫(xiě)法如下:
select pa from Student pa inner join pa.Courses as course where course.name="數學(xué)"
兩個(gè)對象:
學(xué)生表:Student
課程表:Course
兩者的關(guān)系是多對多,當查詢(xún)Student對象,并以Course對象作為條件時(shí)的sql語(yǔ)句寫(xiě)法如下:
select pa from Student pa inner join pa.Courses as course where course.name="數學(xué)"
聯(lián)系客服