multiple tables query

[ognjenovic]

Hello everyone, I have problem with multiple tables... I made database for warehouse, I have tables:customers, suplliers, products, input, output, all tables are related. Everything is working ok, but i dont know how to make samething that i called ''card of products'' where I would be able to see in one place data from few tables(date when products came and quantity(input)and supllier, date and quantity when products were sold(output) and buyers, and total(input - outpu). Trouble is that when i make query with these fields, if i have for example 1 input and 3 outputs-query result is same input repeated for 3 times and 3 outputs... I try to salve this problem(try different joins, unique values, unique rows...) but with no success, so be gratefull for any advice. Thanks a lot!
P.S. Sory for my english, I hope you understand me...

 

[khawar]

Try union queries

 

[nahar0505]

Salam khawar,

Im naharudin from Malaysia. Need your help regarding balance brought forward, I m try to copy your union query but it not working.

can you give a sample

thank you