jurisdictionReference 테이블
-----------------------------------
eid | specificationUrl
-----------------------------------
JD0001 | http://www....
-----------------------------------
jurisdictionSpecification 테이블
-----------------------------------------------------
eid | name | postalCode | countryCode
-----------------------------------------------------
JD0002 | Amazon | 32894 | DE
JD0003 | Galois | 11000 | FR
-----------------------------------------------------
위 두 테이블에서 아래와 같은 테이블을 만들려고 하는데 어떻게 쿼리를 날려야 하나요?
------------------------------------------------------------------------
eid | specificationUrl | name | postalCode | countryCode
------------------------------------------------------------------------
JD0001 | http://www.... | | |
JD0002 | | Amazon | 32894 | DE
JD0003 | | Galois | 11000 | FR
------------------------------------------------------------------------
|