Re: OT: SQL Query Depending on value

2002-05-20 Thread Paul Giesenhagen
Yes, that is where the problem arises... Basically if inventory is > 0 show the item... no problems, but if the inventory level is <= 0 I need to see if backordering is allowed and if it is, show the item, if it isn't do not show the item. Make sense? Paul Giesenhagen QuillDesign > First thi

Re: OT: SQL Query Depending on value

2002-05-20 Thread Jann VanOver
First thing I see, Paul is that you say "if inventory is 0 or below, then I need to check backorder value" But your SQL says: ... and inventory > 0 ... ??? Aren't these opposites? On 5/20/02 8:38 PM, "Paul Giesenhagen" <[EMAIL PROTECTED]> wrote: > I am writing a join query that displays

OT: SQL Query Depending on value

2002-05-20 Thread Paul Giesenhagen
I am writing a join query that displays information depending on a value, There are two columns that deal with inventory, they are inventory = number in stock (could be a negative) backorder = either a 1/0 do we allow backordering or not, if it is 1 Yes, we allow backordering if 0 No we do not.