Hello Everyone
Is this method correct for relate a two queries?
I have a Table for Order , and also I have a Table for Purchase , Even I be able to control my Goods
I want to know how many kind of Goods have I in any Products factory ,,, Maybe I will have relate with more than 10 factories to buy Goods from them .
so that , I want to know How many kinds of any kinds of Goods I have in every factories .
for example : I have these kinds of Goods _
20*40 = 10 tons , Price : 200$ , Factory Name = A
20*20 = 15 tons , Price : 200$ , Factory Name = A
30*30 = 20 tons , Price : 220$ , Factory Name = B
40*40 = 20 tons , Price : 220$ , factory Name = B
I created a related between both , even it shows me detection of materials , which kinds of Goods have I in any factories ( kinds of Goods , Price and Factory )even it tells me , you have : 20*40 = 10 tons , price : 200$ , Factory Name = A .... and so on .