How can I make this query more efficient??

[Achilles]

select s.submittal_Log_id, s.File_Name, Data_Source_Code,
obs.RecCount,s.file_notes
from submittal_log s,
(Select Submittal_Log_ID, count(*) as RecCount
from air_obs
group by Submittal_Log_ID) AS Obs
where Obs.Submittal_Log_ID = s.Submittal_Log_ID and accepted_yn = 'y'
Order by s.File_Name