Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nested Joins??
Message
General information
Forum:
Microsoft Office
Category:
Access
Title:
Nested Joins??
Environment versions
Microsoft Office:
Office 2007
Miscellaneous
Thread ID:
01360946
Message ID:
01360946
Views:
54
I'm trying to understand this MS Access 2002 query:
strSQL = "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)=" & intPKID & "));"
    
I've never see JOINs nested before. Anyone know this well enough to explain it to me?
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