I have three tables with the following structure:
POLICY COVER DEFFECDATE DNULLDATE GP_ID
600001 1 30/03/2010 30/06/2010 6830
600001 62 30/03/2010 30/06/2010 8175
600001 1 30/06/2010 NULL 6872
what are the fields that hold it all together? We will need something in one table that ties it to the next. All three tables can have different fields that tie them together. For instance, it looks like POLICY is the Premium table and Premium_Detail tables both have a field called POLICY. I look at the data and see that it holds the same information. However, Policy & EffecDate look like they may be unique (when queried together) and may be what you ned to link the 2 tables. The Premium_Detail either connects with the Premuim table using the NRECEIPT field?