6

enter image description here Here in this example it states that performs a self-join, but it joins Sales.SalesPerson to Sales.SalesTerritory. I knew that self join means joining the same table to itself but here aren't Sales.SalesPerson and Sales.SalesTerritory different tables? So is this considered self join though the tables are different? or is there a mistake?

source link

  • 1
    Are SalesPerson and SalesTerritory tables or views of the same table? – McNets Feb 20 '19 at 16:52
  • It's not mentioned in the example, but I just checked in AdventureWorks database and they are different tables @McNets – igelr Feb 20 '19 at 16:55
  • I also think so @ypercubeᵀᴹ – igelr Feb 20 '19 at 16:59
7

Looks like you are right in all observations and it is a mistake.

They are two separate tables (not views) and a self-join means a table joined to itself (and even a view or derived table or CTE joined to itself). You might even consider a join between a table and a view derived from that table to be a self-join but it is not the case here either.

I suggest you submit a bug report.

Link: list of AdventureWorks tables.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.