You would be much better off using an exists clause if you had a pk on the table.

i.e.

SELECT *

FROM t_retail a

WHERE EXISTS ( SELECT b.Pcde6P

...