Is there a simple maual for a newby for working with the join editor in IDT? If i check cardinality i get
1,n=1,1
I understand the concept but dont understand how to set the join in the editor.
Options are 2 outerjoin boxes, one join quick link box and close to that, a pulldown menu with sql symbols =, >,< >=, <= .
Can someone point me to a (graphic) manual or explain how it works?
tantetruus (BOB member since 2008-11-11)
hope this helps
BarkyBaloo (BOB member since 2007-07-04)
Nice one!
Still miss some detail though.
In my (test)case i have one (main)table with 54393 rows and a “secundairy” one with 7721 rows.
If i use an outer join the result gives 54605 rows.
That can’t be right, can it?
tantetruus (BOB member since 2008-11-11)
That could be right. It depends on how you configured the join (left outer, right outer, or full outer) and on the actual data and the relationship between the tables… is it one to one, one to many, or many to many?
dtolley (BOB member since 2006-07-14)
it’s left an outer join
tantetruus (BOB member since 2008-11-11)