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.