On 14 Aug 2002, at 14:09, Richard Baskett wrote: > SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS > Comp, Jobs.JobID, Employers.EmpID > FROM Employers > INNER JOIN Jobs ON Employers.EmpID = Jobs.EmpID > INNER JOIN JobsLocation ON Jobs.JobID = JobsLocation.JobID > INNER JOIN Location ON JobsLocation.LocID = Location.LocID > WHERE Valid = 1 AND JobTitle IS NOT NULL AND ( > LocName > LIKE 'US-Alabama%' > ) > ORDER BY Loc ASC
Maybe try changing the FROM part to ... FROM Location STRAIGHT_JOIN JobsLocation ON JobsLocation.LocID = Location.LocID INNER JOIN Jobs ON Jobs.JobID = JobsLocation.JobID INNER JOIN Employers ON Employers.EmpID = Jobs.EmpID ... to force MySQL to use the Location table first? I'm assuming the location selection is the criterion that will really cut down the number of rows (as opposed to the Valid and JobTitle checks). -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
