Skip to Content
0
Former Member
Apr 14, 2014 at 07:10 PM

Duplicate records in SQ00 query

72 Views

HI,

I am trying to make a query joining 3 tables. All tables have atleast 1 key field in common. In the output I have all fields from the main table, 3 fields from table "B" with a left outer join and 1 field from table "C" with an inner join. I am recieving duplicate records in the output. Is this issue a result of incorrect join conditions or is something else needed. Below is an illustration of join conditions.

I look forward to your responses

Regards,

Curt

Attachments