左外部結合

Tweet

こういうテーブルを結合して、左外部結合したいとき。

結合したい左側のテーブル

結合したい右側のテーブル

期待する結果

SQL

select 
project_images.project_image_id,
project_images.project_id,
project_images.list,
project_images.field_id,
project_images.name,
project_images.rank,
images.image_id,
images.filename,
images.item_id,
images.moved,
images.create_date

from project_images 
left outer join (select * from images where item_id=2955297) AS images
on project_images.project_image_id = images.project_image_id where project_images.project_id=502
order by project_images.rank asc