[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