Im struggling with the join definition in IDT (Newbie…)
I join 2 tables which both have a “Clientid” so i join on that field.
I check the box under table 1 (should be a left join?) and then look at hte comlumn values to see
whether it works (which it doesnt…)
What i get is when i mark both the Clientid and the surnames,
is 200 unique ClientID’s and only 1 unique surname.
If i check the box under table 2, i get 16 unique surnames and only one unique Clientid.
What i’m looking for is to get (in this case) 200 unique Clientis’s AND 16 Unique surnames.
I expect it to work as a left outer join but for some reason it doesnt seem to work like that?
Does anyone else has this fenomenom where a left outer join behaves like an inner join?
tantetruus (BOB member since 2008-11-11)