Clay Clay - 29 days ago 14
SQL Question

SQL(MS Access) syntax . Thank you in advance

Trying to find all these that are not in warehouse number 3 and unit price less than 100. Whats wrong with my code? Thank you in advance

select part_number,
part_description,
Units_on_Hand,
Unit_price,
Warehouse_number
from part
where unit_price >= 100
and not in warehouse_number = 3;

Answer
SELECT part_number, part_description, Units_on_Hand, Unit_price, Warehouse_number 
FROM part 
Where unit_price >= 100 AND warehouse_number NOT IN (3);
Comments