Query Syntax help!

I am running this query in Access 2007 and getting a syntax error on this query

UPDATE INQuery SET Awords=(SELECT Coalsce("SELECT (parentdesc & '/' & keyword) From Awords     LEFT JOIN INQuery ON Awords.id=INQuery.item_id",";")) 
WHERE Awords.id=IN_Query.item_id;

System error in query expression '(SELECT Coalsce("SELECT (开发者_如何学Goparentdesc & '/' & keyword) From Awords LEFT JOIN INQuery ON Awords.id=INQuery.item_id",";"))'.

When I run the query expression separately I get the desired result.

NOTE: To see what Coalsce function is please refer VBA + String splitting

Do you actually need the additional SELECT?

UPDATE INQuery SET Awords=Coalsce(...) WHERE ...

Could it be that it's Coalesce not Coalsce? (typo?)