我有以下查询,这是“错误的”
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