Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unnesting Joins
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Unnesting Joins
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01361442
Message ID:
01361442
Vues:
59
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform