How can I show related data that exists inside same table.
MainNum1=A1 SecNum1=zzz Loc1=There
MainNum2=zzz SecNum2=67 Loc2=Here
MainNum3=A1 SecNum3=yy Loc3=Here
MainNum4=yy SecNum4=88 Loc4=Here
How can I find all the MainNum's whose SecNum's location is not There
ie If table were only the 4 records above
I would like to perform find that shows just the first record because zzz's location is not "There"
Thanks in advance