home *** CD-ROM | disk | FTP | other *** search
- ****Query 1 û Using the "Join" Syntax****
- SELECT Category.Name, Course.Number, Course.Title,
- IIf([Cost]>0,Format([Cost],"Currency"),"-") AS CourseCost,
- Format([Start_Date],"mmm d"", ""yy") &
- IIf([End_Date]<>[Start_Date]," to " & Format([End_Date],"mmm d"", ""yy"),"") AS DateRange
- FROM (((Schedule INNER JOIN Course ON
- Schedule.Course_Id = Course.Id)
- INNER JOIN Instructor ON Schedule.Instructor = Instructor.Id)
- INNER JOIN Location ON Schedule.Location = Location.Id)
- INNER JOIN Category ON Course.Category = Category.Id
- WHERE (((Schedule.Start_Date)>Now()))
- ORDER BY Category.Name, Course.Number;