我有以下查询,这是“错误的”

    select
        request0_.id as id1_12_,
        request0_.pdf_path as pdf_path2_12_
    from
        request request0_
    cross join
        ptol_user ptoluser1_
    where
        request0_.auditor_user_id=ptoluser1_.id
        and request0_.applicant_user_id=3
    order by
        ptoluser1_.last_name asc


我想使此查询按第二个表中的姓氏排序,但在某些行中varvhar为null,并且由于第一个条件在哪里使它们消失。如果是可能的话,我想一些解决方案,并进入java jpa以用于春季

最佳答案

如果要在第二张表中包括不匹配的行,则需要使用LEFT JOIN,而不是CROSS JOIN

SELECT request0_.id as id1_12_, request0_.pdf_path as pdf_path2_12_
FROM request as request0_
LEFT JOIN ptol_user AS ptoluser1_ ON request0_.auditor_user_id = ptoluser1_.id
WHERE request0_.applicant_user_id = 3
ORDER BY ptoluser1_.last_name ASC

09-10 08:09
查看更多