SQL Problem

[Michael Puk]

Hi ,
I want to write a SQL in ms Access : Insert into Tab_C by Select Tab_A
Inner Join with Tab_B
The examples are list below. The result is shown in Tab_C

Grateful if any expert tell me how to write this SQL
Thank you.

Tab_A Tab_B
Ac_No A_Item A_Total Ac_No B_Item B_Total
1 CAT 20 1 CAT
12
1 CAT 5 2 CAT
3
2 CAT 11 2 CAT
17
2 DOG 6 2 DOG
21
2 DOG 2 3 CAT
26
3 CAT 7 3 CAT
2
4 DOG 15 4 DOG
11

Tab_C
Ac_No A_Item A_Total B_Item B_Total
1 CAT 25 CAT
12
2 CAT 11 CAT
20
2 DOG 8 DOG
21
3 CAT 7 CAT
28
4 DOG 15 DOG
11