Multiple Child Records in single query

[mfaisal.ce]

Dear Friends,

Kindly guide me,

1. T1 (ID,Name) --- Master Table
2. T2(ID,Qty) ----- Child Table

Now, my question is how i can make a query, which will sum(qty) from T2 against each record in T1....

Example ;

	T1
	ID	Name
1	A1	Pent
2	A2	Shirt
3	A3	Jeans

	T2
	ID	Qty
1	A1	100
2	A2	50
3	A3	70
4	A1	50
5	A2	45
6	A3	100
7	A1	100
8	A2	80
9	A3	90

 

[mike60smart]

You need to get the table structure correct

Can you upload a zipped copy of the database?

 

[mike60smart]

Dear Friends,

Kindly guide me,

1. T1 (ID,Name) --- Master Table
2. T2(ID,Qty) ----- Child Table

Now, my question is how i can make a query, which will sum(qty) from T2 against each record in T1....

Example ;

	T1
	ID	Name
1	A1	Pent
2	A2	Shirt
3	A3	Jeans

	T2
	ID	Qty
1	A1	100
2	A2	50
3	A3	70
4	A1	50
5	A2	45
6	A3	100
7	A1	100
8	A2	80
9	A3	90

Hi
See the attached example.
Study the relationships between table1 and table2

The query1 gives you the Total Quantities