Does memsql support Full Outer Join?

Question

I wanted to have a full outer join in memsql. Sort of

SELECT *
FROM A FULL OUTER JOIN B
ON A.id  = B.id

Is it possible?

Answer 1

Based on the link to the MemSQL documentation provided in the comment above from @Ruchi, it looks like MemSQL does not have syntax FULL OUTER JOIN, However, you should be able to simulate a full external connection in MemSQL using a combination of operations LEFTand RIGHT OUTER JOIN:

SELECT * FROM A
LEFT OUTER JOIN B ON A.id = B.id
UNION ALL
SELECT * FROM A
RIGHT OUTER JOIN B on A.id = B.id
WHERE ISNULL(A.id)

                                               

SELECT , A B A, B. B, A. UNION ALL UNION , .