在单个查询中从两个不同的表中获取详细信息

Question

I have a table called project and another table student. I want to fetch all the details about the project and all the details of the student in that project from single query. student table has project id as foreign key.There can be many students in a project.

Answer 1

Select p.*,s.*(for all columns) from project p, Student s 
inner join p.id=s.id