Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unnesting Joins
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Unnesting Joins
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01361442
Message ID:
01361442
Views:
60
In the following query, I'm not sure how to un-nest the JOIN's. From what I can see, the relationships are all one to one. Can someone help me untangle this?
SELECT	tblContact.LastName,
		tblContact.FirstName,
		tblClientSite.SiteName,
		tblClientSite.Address1,
		tblClientSite.Address2,
		tblClientSite.City,
		tblClientSite.State,
		tblClientSite.ZIP,
		tblContact.Phone,
		tblContact.Fax,
		tblContact.Email,
		tblSalesperson.LastName,
		tblSalesperson.FirstName,
		tblSalesperson.PhoneNumber,
		tblSalesperson.Extension,
		tblSalesperson.Email,
		tblQuote_Original.ContractNumber,
		tblQuote_Version.Version,
		tblQuote_Version.VersionDate,
		tblQuote_Version.UnivDisc,
		tblQuote_Version.UnivDesc,
		tblQuote_Version.EffectiveDate,
		tblQuote_Version.SupportTSA,
		tblQuote_Version.PlatformTSA,
		tblQuote_Version.SeriesTSA,
		tblQuote_Version.UsersTSA,
		tblQuote_Version.AddProdsTSA,
		tblQuote_Version.CostTSA,
		tblQuote_Version.SupportRSAESS,
		tblQuote_Version.PlatformRSAESS,
		tblQuote_Version.SeriesRSAESS,
		tblQuote_Version.UsersRSAESS,
		tblQuote_Version.AddProdsRSAESS,
		tblQuote_Version.HoursPerYear,
		tblQuote_Version.CostRSAESS,
		tblQuote_Version.CoS,
		tblQuote_Version.DistCE 
	FROM tblClientSite 
	INNER JOIN (tblContact 
		INNER JOIN (tblSalesperson 
			INNER JOIN (tblQuote_Original 
				INNER JOIN tblQuote_Version 
				ON tblQuote_Original.PK_ID = tblQuote_Version.FK_Quote_OriginalID) 
			ON tblSalesperson.PK_ID = tblQuote_Original.FK_Salesperson) 
		ON tblContact.PK_ID = tblQuote_Original.FK_Contact) 
	ON (tblClientSite.PK_ID = tblQuote_Original.FK_ClientSite) AND (tblClientSite.PK_ID = tblContact.FK_ClientSite)
	WHERE tblQuote_Version.PK_ID = 356
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform