Based on my original data, i have these fields: Table1 ID Var1 Var2_id Var2 Var3_id Var3 Var4_id Var4 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 111 Prod 1 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 112 Prod 2 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 113 Prod 3 . . . . Table2 Var2_id Var2 Var3_id Var3 Var4_id Var4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i would like to test for any ID and Var1 t1.var2_id=t2.var2_id , test=valid t1.var3_id=t2.var3_id, test=valid t1.var3_id=t2.var3_id, test=valid or t1.var2_id^=t2.var2_id, test=invalid t1.var3_id^=t2.var3_id, test=invalid t1.var3_id^=t2.var3_id, test=invalid sometimes for the same ID and Var1 you might not find t2.Var2_id or t2.Var3_id or t2.Var4_id in table1 (t1) then test =missing i hope this will help to get the picture of what i am facing. Exactly the same number of variables as my work data. thanks
... View more