Hi,
SELECT T2.TariffName 'TariffPointsMainName', T1.TariffName 'TariffPointsChildName',
ISNULL((SELECT NotesQuantity FROM Table1 WHERE TariffPointsSubId=T2.ParentId AND TariffPointsMainId=T2.ID),0) * T2.Price 'GrossTotal'
FROM Table2 T1
INNER JOIN Table2 T2 ON T1.ID = T2.ParentId
WHERE T2.ParentId <>0
ORDER BY T2.ParentId, T2.ID
Regards,
GVPrabu