SELECT ; consigne.o_label AS o_labela, ; contemp.o_label AS o_labelb, ; consigne.o_address1,; consigne.o_address2, ; consigne.o_city, ; consigne.o_state, ; consigne.o_zip ; FROM ; consigne, contemp ; WHERE ; consigne.o_label <> contemp.o_label AND ; consigne.o_address1 = contemp.o_address1 AND ; consigne.o_address2 = contemp.o_address2 AND ; consigne.o_city = contemp.o_city AND; consigne.o_state = contemp.o_state AND ; consigne.o_zip = contemp.o_zip ; GROUP BY consigne.o_address1+consigne.o_address2+; consigne.o_city+consigne.o_state+consigne.o_zip ; INTO TABLE ; (lcDatapath+'condupe.dbf')Try that way