Re: SQL Query Depending on value

ker.net.nz/inform2 > */ > > > > > -Original Message- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 21 May 2002 3:38 p.m. > > To: CF-Talk > > Subject: OT: SQL Query Depending on value > > > > > > I am writi

RE: SQL Query Depending on value

nhagen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 21 May 2002 3:38 p.m. > To: CF-Talk > Subject: OT: SQL Query Depending on value > > > I am writing a join query that displays information depending > on a value, > > There are two columns that deal with inventory, they are

Re: OT: SQL Query Depending on value

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

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

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.