IIF in query not working

[luckycharms]

Hi Folks,

I'm trying to get the following query working in Access 2007, but I get a "Syntax Error (missing operator) in query expression" error. Any help would be greatly appreciated!

SELECT i.*, IIF(isNull(b.mID),0,1) LEFT JOIN iTable i ON bTable b WHERE i.mID = b.mID

 

[Galaxiom]

Hard to be sure what you are after but this might be it.
SELECT i.*, IIF(isNull(b.mID),0,1) AS somename FROM b LEFT JOIN i ON i.mID = b.mID