Hi, I would like to compare two tables row by row having same primary keys. The comparison should take each row from TABLE1 and find relevant entry (based on KEY) from TABLE2 and compare value of EACH column.
For the TABLE1 and TABLE2 below, the values of COL4 for KEY3 should be returned (both values). TABLE1 COL1 COL2 COL3 COL4 KEY1 X Y Z KEY2 A B C KEY3 K L M TABLE2 COL1 COL2 COL3 COL4 KEY1 X Y Z KEY2 A B C KEY3 K L D Is there a way to do this via SQL or I will try to do it with C loops (which ends up with nasty code!). Thanks in advance... _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users