SELECT fields from tablea
WHERE ipd_prod not in ( select distinct ipd_prod from table b )
AND ipd_prod <> 'bulk'

this will print all data which is in tableB and not in tableA

I just replace tableA as tableB and tableB as tableA then it will so the data I required.

thanks for your suggetion