Prevent automatic joins when adding tables?

microsoft.public.sqlserver.tools

20 Jan 2005 8:21 AM

Will Hughes

Hi,

Is it possible to configure Enterprise Manager to NOT automatically add
joins when adding a table using the GUI tool?

Or is there a better GUI tool for building sql. I'm doing some rather large
joins with dozens of tables and doing the sql manually has gotten a bit
difficult.

TIA

20 Jan 2005 12:08 PM

Tom Moreau

EM is very limited in its query building capability. Use QA and learn SQL.
If you find you're doing the same joins over and over again, create some
views.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..

"Will Hughes" <Will Hug***@discussions.microsoft.com> wrote in message
news:18130DC3-748D-46EB-9157-3ED22EBA8C23@microsoft.com...
Hi,

Is it possible to configure Enterprise Manager to NOT automatically add
joins when adding a table using the GUI tool?

Or is there a better GUI tool for building sql. I'm doing some rather large
joins with dozens of tables and doing the sql manually has gotten a bit
difficult.

TIA