Re: query won't return results
- From: Joanne <jobobbuss@xxxxxxxxxxxxx>
- Date: Sat, 02 Apr 2005 20:25:16 GMT
Ken
Thanks for your consideration of my problem.
Following is the SQL statement of my query
SELECT tblCourses.CourseID, tblCourses.Name, tblCourses.Street1,
tblCourses.City, tblCourses.State, tblCourses.Zip, tblCourses.Phone,
tblCourses.WebSite, tblHoles.HoleID, tblHoles.HoleNumber,
tblHoles.WhiteTees, tblHoles.RedTees, tblHoles.Par AS tblHoles_Par,
tblScores.ScoreID, tblScores.Date, tblScores.Green, tblScores.Fairway,
tblScores.Sand, tblScores.Water, tblScores.Lost, tblScores.Fringe,
tblScores.Approach, tblScores.Putts, tblScores.Pars
FROM (tblCourses INNER JOIN tblHoles ON tblCourses.CourseID =
tblHoles.CourseID) INNER JOIN tblScores ON tblHoles.HoleID =
tblScores.HoleID;
Ken Snell [MVP] wrote:
>What query are you trying to use? Post the SQL statement of it.
>
.
- Follow-Ups:
- Re: query won't return results
- From: Ken Snell [MVP]
- Re: query won't return results
- References:
- query won't return results
- From: Joanne
- Re: query won't return results
- From: Ken Snell [MVP]
- query won't return results
- Prev by Date: Append query using paramters
- Next by Date: Re: query won't return results
- Previous by thread: Re: query won't return results
- Next by thread: Re: query won't return results
- Index(es):
Relevant Pages
|
