Help ! SQL problem in mySQL

[lelij]

The below, using a stored query, works fine in Access but not in mySQL, which doesn't support it ( sigh ).

Currently, my query is:

SELECT PLogin, PID, PDate, PTitle, PApplyOnline, PExpiry, PStatus, IIf(IsNull([Nbr]),0,[Nbr]) AS NbrCV
FROM Posting LEFT JOIN ActiveApplicationByAPID ON Posting.PID = ActiveApplicationByAPID.APID;

calling the stored Query ActiveApplicationbyAPID :

SELECT Applications.APID, Count(Applications.AEmail) AS Nbr
FROM Applications
WHERE (((Applications.AStatus)='4'))
GROUP BY Applications.APID;

The fact that subqueries don't work either, doesn't simplify things for me.
Anyone have any idea how to create one SQL query which will produce the same result in mySQL?

Thanks!