Self Join Query - Emmanuel Katto

Hi,

I am Emmanuel Katto from UK. Can someone tell me is SELF JOIN an INNER JOIN or OUTER JOIN?

Thanks! Emmanuel

Never heard of SELF JOIN in MySQL or MariaDB. I'm nearly sure it does not exist. So where did you see it?

@emmanuelkatto:

There are four main types of JOINs in SQL: INNER JOIN, OUTER JOIN, CROSS JOIN, and SELF JOIN which (in itself) already implies that a SELF JOIN is none of the others. With other words it operates on one table only, hence there is no intersection (the defining element of an INNER or OUTER join).

Hi,

I am Emmanuel Katto from UK. Can someone tell me is SELF JOIN an INNER JOIN or OUTER JOIN?

Thanks! Emmanuel

This forum is mostly about the HEIDI SQL product, try to find any tutorial with google help, there is a lot of it everywhere.

Thanks @TTSneko for the answer.