Skip to content

Instantly share code, notes, and snippets.

@KimSoungRyoul

KimSoungRyoul/inner join 안하고 subQuery로도 하고싶다.sql

Created April 21, 2019 14:25
Show Gist options
  • Save KimSoungRyoul/93cefaec62176a49cf2984eb7e040a59 to your computer and use it in GitHub Desktop.
Save KimSoungRyoul/93cefaec62176a49cf2984eb7e040a59 to your computer and use it in GitHub Desktop.
Download ZIP
ORM에서 쿼리 전략을 변경하는 것이 가능할까?
Raw
inner join 안하고 subQuery로도 하고싶다.sql
SELECT *,
(select "descriptions"
from orm_practice_app_order
where "orm_practice_app_orderedproduct"."related_order_id" = "orm_practice_app_order"."id"
AND "descriptions" = '주문의 상세내용입니다...1') as descriptions
FROM "orm_practice_app_orderedproduct"
WHERE "orm_practice_app_orderedproduct"."id" = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment