Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Another query problem

    My other problem relates directly to a query about stock levels. Being a stock control system this is a major part of the project which has to work. I've got the correct figures for the stock purchased. However, it has grouped the stock in a weird way. I want it to show the quantity of books purchased from the supplier and then the quantity of books sold to the customer. Logically the formula should be the difference of the quantitys which will result in the total quantity of each book left in the stock room. But it doesnt. There seems to be something wrong with how it groups each product ID. I want only one of each product ID but showing many quantitys NOT many of each product ID'S.

    Any suggestions please?

  2. #2
    Join Date
    Jul 2003
    Can you post your SQL here? It makes it easier to see what you are trying to do.
    Inspiration Through Fermentation

Posting Permissions

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