select *, recid from message where recid in [1]
I've also tried my other table attachment with the same result. Also
select *, recid from message where message.recid in [1]
gives an error "unexpected token in". The same queries work fine in my Xojo code, by the way.