dqsong2010 2016-06-02 17:12
浏览 39
已采纳

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

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.

  • 写回答

3条回答 默认 最新

  • doufuxi7093 2016-06-02 17:25
    关注
    Select p.*,s.*(for all columns) from project p, Student s 
    inner join p.id=s.id
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?