KEY |
LEFT |
RIGHT |
Matched row |
||
One-to-many match |
||
Unmatched row |
Policy Ref |
Insured |
Incept |
Expiry |
AB123456 |
General Insure |
1/1/2010 |
31/12/2010 |
AB123457 |
Etc Insure |
1/1/2010 |
31/12/2010 |
AB123458 |
More Insure |
1/1/2010 |
31/12/2010 |
AB123459 |
Less Insure |
1/1/2010 |
31/12/2010 |
AB123461 |
XYZ Insure |
1/1/2010 |
31/12/2010 |
Policy Ref |
Property |
Contents |
AB123457 |
5 Main Road |
75,000 |
AB123457 |
1 Highway |
80,000 |
AB123458 |
74 Highstreet |
75,000 |
AB123459 |
24 Chestnut Avenue |
50,000 |
AB123460 |
99 Red Balloon Way |
50,000 |
AB123461 |
12 Grove Road |
60,000 |
AB123462 |
36 Acacia Avenue |
40,000 |
Policy Ref |
Insured |
Incept |
Expiry |
Policy Ref (Table 2) |
Property |
Contents |
AB123456 |
General Insure |
1/1/2010 |
31/12/2010 |
|||
AB123457 |
Etc Insure |
1/1/2010 |
31/12/2010 |
AB123457 |
5 Main Road |
75,000 |
AB123457 |
Etc Insure |
1/1/2010 |
31/12/2010 |
AB123457 |
1 Highway |
80,000 |
AB123458 |
More Insure |
1/1/2010 |
31/12/2010 |
AB123458 |
74 Highstreet |
75,000 |
AB123459 |
Less Insure |
1/1/2010 |
31/12/2010 |
AB123459 |
24 Chestnut Avenue |
50,000 |
AB123461 |
XYZ Insure |
1/1/2010 |
31/12/2010 |
AB123461 |
12 Grove Road |
60,000 |
Policy Ref |
Property |
Contents |
AB123460 |
99 Red Balloon Way |
50,000 |
AB123462 |
36 Acacia Avenue |
40,000 |