Update tables

W

Wantula

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]
 
K

Ken Snell [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update another table afterinsert 9
Update Tables 3
SQL Statement 2
Subquery with subraction - challenging 4
SQL 3
database with yearly split data 12
Update a Table 1
Calculate Percent Return for Stocks 5

Top