[thelist] [sql] cross join - solved
Paul Bennett
paul at teltest.com
Wed Aug 27 23:34:56 CDT 2003
Solved my own question. Doh!
The query (for anyone wondering)
select
WP_courses_imported.Title
,WP_courses_imported.WeeksPerYear
,WP_courses_imported.HoursPerWeek
,WP_courses_imported.Online
,WP_courses_imported.AimDescription
,WP_courses_imported.CareerOpportunities
,WP_courses_imported.EntryCriteria
,WP_courses_imported.InternationalEntryCriteria
,WP_programme_career_key.careerKey
,WP_careers.careerName
from
WP_courses_imported
left join
WP_programme_career_key
on
(WP_courses_imported.CourseKey = WP_programme_career_key.courseKey)
left join
WP_careers
on
(WP_careers.careerKey = WP_programme_career_key.careerKey)
where
WP_courses_imported.CourseKey = 3
--
------------------------------
Paul Bennett
Internet Developer
Teltest Electronic Design
------------------------------
Email: paul at teltest.com
Phone: 64 4 237 4557
Web: http://www.teltest.com
Wap: http://wap.teltest.com
More information about the thelist
mailing list