I have a sql query that give s GPV under odd conditions.  It's only if I 
use a right join and DISTINCT. The below query causes a GPV but if I 
remove the DISTINCT or change the RIGHT to LEFT it works.
Seems like that would be table corruption but I've run the tables 
through Chimney Sweep and they seem ok.  Any thoughts?

SELECT  DISTINCT pn.*
FROM 'CONFIG_ASSYLIST.DB' cfassy
RIGHT  JOIN '-PARTNUM.DB' pn
ON  cfassy.'pnfkey' = pn.'Link #'
WHERE cfassy.'ConfigRevfkey'= 1526