<p><b>안녕하세요. 지금 현재 쿼리문으로 한번 구현을하고 있는데&nbsp;</b></p>
<p><b>아래 처럼 query를 하고싶은데 JOIN을 하는건 알겠는데 이게 무슨 JOIN을 해야지 이렇게 같이 데이터가 들어가는지 </b></p>
<p><b>잘 모르겠네요.</b></p>
<div style="color: #d4d4d4; background-color: #1e1e1e; font-family: Consolas, 'Courier New', monospace; font-size: 14px; line-height: 19px; white-space: pre;">
<div>&nbsp;<span style="color: #9cdcfe;">where</span><span style="color: #9cdcfe;">:</span>&nbsp;{</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">PostId</span><span style="color: #9cdcfe;">:</span>&nbsp;<span style="color: #9cdcfe;">req</span>.<span style="color: #9cdcfe;">params</span>.<span style="color: #9cdcfe;">id</span>,</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;},</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">order</span><span style="color: #9cdcfe;">:</span>&nbsp;[[</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #ce9178;">'createdAt'</span>,&nbsp;<span style="color: #ce9178;">'ASC'</span></div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;]],</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">include</span><span style="color: #9cdcfe;">:</span>&nbsp;[{</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">model</span><span style="color: #9cdcfe;">:</span>&nbsp;<span style="color: #4fc1ff;">db</span>.<span style="color: #9cdcfe;">User</span>,</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">attributes</span><span style="color: #9cdcfe;">:</span>&nbsp;[<span style="color: #ce9178;">'id'</span>,&nbsp;<span style="color: #ce9178;">'nickname'</span>],</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}],</div>
</div>

<p>knex라는 쿼리빌더가 있습니다. orm보다는 기능은 약하지만 쿼리를 자바스크립트를 통해서 만들어줍니다.</p>

<p>저도 시퀄라이즈만 쓰다보니 정확한 JOIN 문법을 까먹었습니다. 이 부분을 직접 SQL 확인하시려면 백엔드 서버 콘솔에 시퀄라이즈가 SQL문을 찍어줍니다.</p>
<p>그리고 어떤 테이블인지도 알려주셔야 하지 않을까요?</p>

<p>그렇군요. 항상 좋은 답변 감사합니다!</p>

<p>쿼리문 사용하면서 정말 시퀄라이즈는 혁명 이구나 했습니다 ㅋㅋㅋ 그 시퀄라이즈랑 또 하나가 knext 맞나요??</p>

Inflearn Community Q&A

댓글 검색 쿼리문으로