klopot z klauzula NOT IN w MySQL

Witam mam problem z zapytanie moglibyscie rzucic okiem

 $wynik = mysql_query("SELECT  sum(Pot.BS) as BS, sum(Pot.BI) as BI, sum(Pot.HS) as HS, sum(Pot.HI) as HI, sum(Pot.capBS) as capBS, sum(Pot.capBI) as capBI, sum(Pot.capHS) as capHS, sum(Pot.capHI) as capHI, Transport_plan.VEHICLE   FROM Pot, Transport_plan  Where  Transport_plan.STORE_ID=Pot.Store and Pot.SKU_CLASS NOT IN (select not.SKU_CLASS from not WHERE not.SKU_CLASS is not null ) and Pot.Customer_Group NOT IN ('HOLD')  Group by  Transport_plan.VEHICLE  ORDER by Transport_plan.VEHICLE asc ") 

Problem dokladnie tkwi w klauzuli NOT IN (subqueries) gdy zrobie stringi po przecinku to dziala ale sub zapytanie nie

Jakies pomysly?

problem rozwiazany SELECT * FROM not dziala bez zarzutu

dlugo sie nie pocieszylem znowy wywala blad tylko teraz kiedy np. not.SKU_CLASS ma spacje w srodku