Microsoft Access SQL Problem

I am having problem with this SQL in MS Access:

This query seem like working fine in most SQL software but not in MS Access. Either I or MS Access suck.