I have a file from wich I want to exclude some lines regarding some criteria.
I have identified them with this query :

SELECT * FROM ab.Price_table
INNER JOIN bib.items ON xxetab=zzetab AND xxitem=zzitem
inner JOIN bib2.spefile
ON zzcod=spcod AND xxdat=spdat AND xxdev=spdev AND spflg= ‘INFO’
WHERE xxpri IN (spPRR1, psPRR2, psPRR3, psPRR4, psPRR5);

this returns me 1 lines.

I want to have all the data from my ab.Price_table without including the line retuned previously
I tried a left join but it’s not working