Update tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Ken Snell, I earlier posted questions(subtraction & re:subtraction), where
i was trying to subtract the results of two SQL statements. this is something
to do with stock on hand. The subtraction is working except that it doesnt
show items that are in stock but havent been sold.It only shows stock on hand
of items that have been sold.However, if I add another table(MASTER), It
shows even items that havent been sold but are in stock.
You can refer to the posting titled Subtraction, posted on 6 th November,
where David Seeto gave me the solution. [Thanks David]
 
Can you post the SQL statement of the query (or queries) that you currently
have? I've reviewed the original thread, but would like to be sure I
understand our starting point for this question.
 
Back
Top