Query to Remove Duplicate Records

Query to ignore duplicate record between two tables....
the comparision columns should be integer....


SELECT   SH.ID,SH.PALLETNO 'Pallet No',SH.SLIPNO 'Slip No',SH.SLIPCOUNT 'Slip Count',MO.MONO,WDH.STLACCPC 'STLACCPC',WDH.WEIGHINGID FROM WH_SCRAPHISTORY SH       
INNER JOIN SL_MILLORDER MO ON MO.ID = SH.MILLORDERID       
INNER JOIN WH_WEIGHINGDTLS_HST WDH ON WDH.ID = SH.WEIGHINGDTLSID       
WHERE      
 CONVERT(VARCHAR,SH.PALLETNO) + CONVERT(VARCHAR,SH.SLIPno)  NOT IN       
(      
SELECT CONVERT(VARCHAR,WD.PALLETNO) + CONVERT(VARCHAR,WD.SLIPno)  FROM WH_WEIGHINGDTLS WD      
INNER JOIN WH_WEIGHING W ON W.ID =  WD.WEIGHINGID  WHERE W.MILLORDERID = @MOID          
)      



Regards
Santosh