Query to dispay all data

[Simon]

My database if for a shop.

I have a query that adds up the quantity of stock that i have bought
and also the quantity of stock i have sold.. Therfor i can work out the

amout of stock left in stock.


Teh problem when i run the query is that if i have not sold any items
of one product it does not show up in the query.


how do i get it to show all the products i have bought but then if i
have not sold any it displays '0' in stead of not desplaying the
recored,


Thanks


Simon

 

[Guest]

You would first need to have your product table in the query. Then you would
need to do an outer join where you would show all records in the product
table and only those records in the bought/sold table that match.

Be sure to have your product number coming from the product table in the
query.

I am hoping your table structure will allow this setup. Let us know if if
does not.

Jackie