Multiple Child Records in single query (1 Viewer)

[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

 

[Pat Hartman]

Select t1.ID, T1.[Name], Sum(T2.Qty) AS Total
From T1 Left Join T2 on T1.ID = T2.ID
Group by T1.ID, T1.[Name]

PS "Name" is the name of a property and so is a poor choice as a column name.