It is the same thing in VFP, you can write joins this way, though I dislike it. Tamar Granor has it documented in her web-site.

>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?