SQL query

Results 1 to 2 of 2

Thread: SQL query

  1. #1
    Join Date
    Dec 1969

    Default SQL query

    CAN ANYBODY SOLVE THIS..........???????????<BR><BR>I have table...<BR> inventory(partId,location,onHand,reorderPoint)<BR> Query is...<BR> want to maintain quantity on hand is at least equal to reorder point<BR> select statements to find partId and quantity that needs to be orderedto maintain a value onHand equal to reorderPoint plus 100<BR><BR> ....Amita<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL query

    select partid, 100 - (onHand - reorderPoint) as neededQuantity<BR>from inventory where onHand - reorderPoint &#060; 100

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts