ms-sql, 두개의 테이블을 조인하면서 ...

Question

(1) A테이블&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;이름 | B테이블 고유값 배열 (varchar)---------------------------------------------------홍길동 | 1,2&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61; (2) B테이블&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;고유값(bigint) | 색상---------------------------------------------------1 | 검정---------------------------------------------------2 | 빨강&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61; (3) A, B 조인결과&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;이름 | 색상---------------------------------------------------홍길동 | 검정, 빨강&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61;&#61; (3)과 같은 결과를 뽑고 싶은데, 조언을 얻을 수 있을까요?

더프앤도프 · Answer

고유값을 왜 배열로 저장하시는건가요,,,?

날라리개발자 · Answer

재귀쿼리를 사용해야합니다with 절로 검색해보세요

seyo · Answer

#안경마을. 기준 정보가 복수의 옵션을 가져야 하기 때문인데, 테이블 수를 줄이면서 쿼리 속도를 높여 보려고 별도 매칭 테이블을 만들지 않았기 때문입니다.

더프앤도프 · Answer

배열로 저장하고 빼보지를 않아서 쿼리 속도 면으로는 잘 모르겠지만, A테이블을 홍길동 1,2 보다 홍길동 1, 홍길동 2 로 fk 먹이는게 조인 했을 때 더 빠르지 않을까요??

ms-sql, 두개의 테이블을 조인하면서 ...

4개의 답변

Q&A 목록