I have a product table with unitsinstock and Reorder level i want to pull only the products that are equal to or less than reorder level.
SELECT Products.[ProductID], Products.[Part Number], Products.[ProductName], Products.[Reorder Level], Products.[UnitsInStock], Products.[UnitPrice]FROM Products
WHERE [Unitsinstock]<=[Reorder Level];
What am i doing wrong im getting a mixture of both
Thanks in advance
Steve