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.