Using SQL Server's Graphical Query Designer

I have been burned for the last time using the SQL Query Designer to create complex joins.

I have used the graphical designers in Access and SQL Server for years and have finally realized (with help from my esteemed colleague Jeremy) that to fully understand the function of the written join is a far superior method of writing complex SQL queries.

The dependency on the graphical designer can sometimes speed up the creation of simple joins, but beyond that, if you don't fully understand your goal and how to write it, you will be in over your head trying to tweak the code that the designer produces. And, the designer formats code so horribly you will spend as much time reformatting it for neatness as it could ever save you.

If you ever notice me using the graphical designer again, please refer me to this post. Thank you.