SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

a simple joint that makes you think twice

I was reading Two Minute SQL Server Stumpers a few weeks ago and this qustion still sticks in my head.  Thanks to SSC for giving it away at PASS :)

SELECT * FROM dbo.Customer MIDDLE JOIN dbo.Employee on CustomerID=EmployeeID.

This puzzle me because I have never heard of a middle join syntax before and it took a long time before I could understand the question. If this puzzle you as well it's ok.  I think it is easier to rephrase the question as:

SELECT * FROM dbo.Customer PURPLE JOIN dbo.Employee on CustomerID=EmployeeID.

I hope you have fun looking at the new syntax.  Please let me know if you have any question.  Thanks.


No comments.

Leave a Comment

Please register or log in to leave a comment.