Question w Appending data

T

Ted

Hi all, sorry for the general subject. I hope I can explain this...

I have a query w multiple tables. For one of the fields I'm linking two
fields from one table to another to pull the mapped value. Its only pulling
the values for some because some of the values are blank in the mapped table
ie...

This is the table I'm mapping to to get the ISO Code value Rackley Field
CANCREASON ISO Code ISO Description
Cancel CBC 11 Cancellation - Nonpayment of Premium
Cancel CBS 11 Cancellation - Company's Option
Cancel CIR 11 Cancellation - Insured's Option
Cancel CNP 12 Cancellation - Company's Option
Cancel CNPFC 12 Cancellation - Insured's Option
Cancel CSB 11 Cancellation - Nonpayment of Premium
Cancel CUW 13 Cancellation - Insured's Option
Cancel FLAT 11 Cancellation - Company's Option
Endorse
15 Endorsement
New Business
18 New Policy
New Business Rollover
18 New Policy
Offset
15 Endorsement
Reinstate
17 Reinstatement


I get the values for all of the records that have a value in the CANCREASON
field and Rackley field but don't get anything for the records that have a
null value in the CANCREASON field. Is there anyway to pull in the ISO code
for records that don't have a value in the CANCREASON field?

TIA!
Ted
 
T

Ted

Sorry the table didn't hold the format. I hope this helps explain my
problem...

Rackley Field CANCREASON ISO Code ISO Description
Cancel CBC 11
Cancellation - Nonpayment of Premium
Cancel CBS 11
Cancellation - Company's Option
Cancel CIR 11
Cancellation - Insured's Option
Cancel CNP 12
Cancellation - Company's Option
Cancel CNPFC 12
Cancellation - Insured's Option
Cancel CSB 11
Cancellation - Nonpayment of Premium
Cancel CUW 13
Cancellation - Insured's Option
Cancel FLAT 11
Cancellation - Company's Option
Endorse 15
Endorsement
New Business 18 New
Policy
New Business Rollover 18 New Policy
Offset 15
Endorsement
Reinstate 17
Reinstatement
 
L

Lord Kelvan

yea use left join rather than inner join

if you double click on the black line connecting the two tables you
will have a list of there options

select fields where tablea.value = tableb.value

select all fields in tablea as well as the fields in tableb where
tablea.value = tableb.value

select all fields in tableb as well as the fields in tablea where
tableb.value = tablea.value

you most likly want the second option thi sis a left join if that
dosnt work try the third option that is a right join

Regards
Kelvan
 
Top