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')