How i make a n1ql its equivalent SQL query?

SQL++
2

Here is the corresponding N1QL.

SELECT mail.id, mail.name, address, viewer
FROM archive mail
LEFT OUTER JOIN archive address
ON KEY address.mailId FOR mail
LEFT OUTER JOIN archive viewer
ON KEY viewer.mailId FOR mail
WHERE mail.type = 'Mail'
AND address.type = 'Address'
AND viewer.type = 'Viewer'
;