SQL语句无法执行，SOS

VBA中，此语句无法运行：

ssql = "select * from (Select Material,Amount  from [sheet1$] union select Material,Amount  from [sheet3$])" & _
       "where Material not in (select (cast Material as text) from [sheet2$])"

何解？

请上传excel附件为宜