Considere duas tabelas X e Y, com as seguintes instâncias:
select *
from X FULL JOIN Y on X.a=Y.c
select *
from X LEFT JOIN Y on X.a=Y.c
select *
from Y RIGHT JOIN X on X.a=Y.c
select *
from X CROSS JOIN Y on X.a=Y.c
select *
from X INNER JOIN Y on X.a=Y.c
{TITLE}
{CONTENT}
{TITLE}
Aguarde, enviando solicitação...