N1QL- Document not found - default value

SQL++
2

If source doesn’t produce any document it will not project.

If you really needs that

SELECT IFMISSINGORNULL(META(p).xattrs._sync.rev,0) AS rev
FROM ["C::100008_157","C::100007_157"] AS key
LEFT JOIN poc AS p ON KEYS key;