Issue with MySQL select where clause in left join
===

I've got an order items & a parts table, which i'm joining on the part ID foreign key:

    select orderID,qty,minorder from orderitem left join parts ON orderitem.partID=parts.partID where orderitem.orderID='2128' AND qty < minorder

When i perform this query, i am getting no results. [When i remove the "qty < minorder" from the where clause, i get the following.][1]

I'm' trying to craft this query so i get the 2nd record (where the qty is less than the minorder).

Any ideas?


  [1]: http://i.stack.imgur.com/EIGB2.png