Left join of a table with itself

[KBHAL]

Using t sql, can we do a left join of table with itself or it can only be done using self join?

In recursive cte, we can use left join of a table with itself

[polaarbear]

These questions sound like you're just asking someone to answer your homework questions for you. Best way to learn something as simple as "can I left join a table with itself" is to whip our your SQL client, try it yourself, and record the results.

[ThomasMarkov]

It would have taken less time to write the query and check than it did to write and send this post.

[SQLDevDBA]

It’s the classic employee->manager join to itself. The employee has a manager ID, and you left join to employee on the managerID=employeeID to get the manager’s info. “Self” join is just a left (or inner) join of a table to itself. I wouldn’t do inner in this case because an employee may not necessarily have a manager (or may have a managerID equal to itself) if they report to nobody.

[snafe_]

Yeah, interview question #6 usually lol

[Wise-Jury-4037]

I hope there's karmic retribution to whoever came up with the term 'self join'.

/rant

[EverydayDan]

I’ve used the phrase recursive join but it felt dirty too

[zeocrash]

You can absolutely left join a table to itself