J
JB
would greatly appreciate assistance in designing a Query for the 2 tables below - fairly simple & straight forward.
I need to combine or join the tables into a single final table named "combined"
I have tried various queries with no success. I seem to get all types of problems, but nothing takes.
What am I doing wrong. This query should be a cinch ! Shouldn't it?
Table 1 is as follows & contains 5019 records
PRIMARY . ci FIRST NAME . ci MIDDLE INITIAL . ci LAST NAME . ci SUFFIX . ci NNS . ci DOB . ci STREET1 . c1 STREET2 . ci CITY . ci STATE . ci ZIP . *FIRST NAME . *MIDDLE NAME . *LAST NAME . PREFIX . SUFFIX . SECONDARY ADDRESS .
*PRIMARY ADDRESS . *CITY . *STATE . *ZIP . *FIELD 11 . *PHONE . *EDT NNS . NNS MATCH LEVEL . NNS DECEASED IND . PHONE PANDER FLAG . DMA PANDER FLAG . TOTAL PANDER FLAG . INVALID INPUT FLAG . RECIPIENT RELIABILITY FLAG
Table 2 is contructed below & contains 1402 records:
Prtimary . First Name . Middle Name . Last Name . EDD NNS . Primary Address . City . State . Zip . Field 11(empty, no data) . Phone
I need to have the records from table 2 added to the fields in table 1 where the "*" is indicated. These fields contain no data but need to be appended to the data file from table 1 with the records from table 2.
Thanks much !
I need to combine or join the tables into a single final table named "combined"
I have tried various queries with no success. I seem to get all types of problems, but nothing takes.
What am I doing wrong. This query should be a cinch ! Shouldn't it?
Table 1 is as follows & contains 5019 records
PRIMARY . ci FIRST NAME . ci MIDDLE INITIAL . ci LAST NAME . ci SUFFIX . ci NNS . ci DOB . ci STREET1 . c1 STREET2 . ci CITY . ci STATE . ci ZIP . *FIRST NAME . *MIDDLE NAME . *LAST NAME . PREFIX . SUFFIX . SECONDARY ADDRESS .
*PRIMARY ADDRESS . *CITY . *STATE . *ZIP . *FIELD 11 . *PHONE . *EDT NNS . NNS MATCH LEVEL . NNS DECEASED IND . PHONE PANDER FLAG . DMA PANDER FLAG . TOTAL PANDER FLAG . INVALID INPUT FLAG . RECIPIENT RELIABILITY FLAG
Table 2 is contructed below & contains 1402 records:
Prtimary . First Name . Middle Name . Last Name . EDD NNS . Primary Address . City . State . Zip . Field 11(empty, no data) . Phone
I need to have the records from table 2 added to the fields in table 1 where the "*" is indicated. These fields contain no data but need to be appended to the data file from table 1 with the records from table 2.
Thanks much !