Codes Re: 求教: Join 两个query (data)# Database - 数据库
w*i
1 楼
OK, the following are the source codes. Actually I think they make the
problems more complicated. Thanks a million for your help!
Subquery 1 (works right) -- name of "hr_contact_add"
function: produce the address list of the people
SELECT [dbo_HRPEOPLE11].[PERSON_ID], [dbo_HRPEOPLE11].[NAME_LAST],
[dbo_HRPEOPLE11].[NAME_FIRST], [dbo_HRPEOPLE11].[NAME_MIDDLE],
[dbo_HRPEOPLE11].[NAME_PREFERRED], [dbo_HRPEOPLE_ADDRESSES11].[ADDRESS_TYPE],
[dbo_HRPEOPLE_ADDRESSES11].[ADR_STREET1],
[dbo_HRPEOPLE_ADDR
problems more complicated. Thanks a million for your help!
Subquery 1 (works right) -- name of "hr_contact_add"
function: produce the address list of the people
SELECT [dbo_HRPEOPLE11].[PERSON_ID], [dbo_HRPEOPLE11].[NAME_LAST],
[dbo_HRPEOPLE11].[NAME_FIRST], [dbo_HRPEOPLE11].[NAME_MIDDLE],
[dbo_HRPEOPLE11].[NAME_PREFERRED], [dbo_HRPEOPLE_ADDRESSES11].[ADDRESS_TYPE],
[dbo_HRPEOPLE_ADDRESSES11].[ADR_STREET1],
[dbo_HRPEOPLE_ADDR