Optimere SQL kald

Tabel_A indeholder bl.a.
A_ID, Bruger_ID

1,1
2,2
3,4
4,5
osv

Tabel_B indeholder bl.a.
B_ID, A_ID, Type, Tal

1,1,"P", 5
2,1,"P", 3
3,1,"M", 2
osv

I dag laver jeg en i PHP loop på SELECT FROM Tabel_A
Inde i det loop laver jeg 2 select:
SELECT SUM(Tal) AS Tal FROM Tabel_B WHERE Type = 'P' && A_ID = [Tabel_A.ID] GROUP BY A_ID

SELECT SUM(Tal) AS Tal FROM Tabel_B WHERE Type = 'M' && A_ID = [Tabel_A.ID] GROUP BY A_ID

Ville gerne kunne lave det om til et SQL kald ala:

SELECT
Tabel_B_P.Tal AS M_Tal, Tabel_B_M.Tal AS M_Tal
FROM Tabel_A
LEFT JOIN (SELECT SUM(Tal) AS Tal FROM Tabel_B WHERE Type = 'P' && A_ID = [Tabel_A.ID] GROUP BY A_ID) AS Tabel_B_P
LEFT JOIN (SELECT SUM(Tal) AS Tal FROM Tabel_B WHERE Type = 'M' && A_ID = [Tabel_A.ID] GROUP BY A_ID) AS Tabel_B_M

Giver det mening?? og kan man det??