I was wondering the sql equivalence of a self-join. As far as I know, a table is joined with itself and its code is something like below;
SELECT A.id, B.id, A.value
FROM test_table A, test_table B
WHERE A.id = B.id
It would be great to learn the missing part in the condition, thanks.
Please sign in to leave a comment.