Stuart Felenstein wrote:
I have this query (below) that on it's own , directly into the database seems to return all the records just fine. Apparently though feeding it into a php loop, the lack of "where" is causing great distress(at least to the author)
I'm wondering where to put it though. Before each join ? And then what does the "from" imply.
The manual gives you the syntax of a select. The WHERE goes after the joins, and before ORDER BY, HAVING, and LIMIT.
Hope I make sense here, delirium is setting in.
:)
Select
VendorJobs.JobID,
VendorJobs.PostStart,
VendorJobs.JobTitle,
VendorJobs.AreaCode,
VendorJobs.PayRate,
VendorJobs.Contact,
VendorJobs.Conmail,
VendorSignUp.CompanyName,
StaIndTypes.CareerCategories,
StaUSCities.City,
USStates.States,
staTaxTerm.TaxTerm,
staTravelReq.TravelReq
From
(((((VendorJobs VendorJobs INNER JOIN VendorSignUp
VendorSignUp ON (VendorJobs.VendorID =
VendorSignUp.VendorID)) INNER JOIN StaIndTypes StaIndTypes ON
(VendorJobs.Industry = StaIndTypes.CareerIDs)) LEFT OUTER JOIN StaUSCities StaUSCities ON
(VendorJobs.LocationCity = StaUSCities.CityID)) INNER JOIN USStates USStates ON
(VendorJobs.LocationState = USStates.StateID)) INNER JOIN staTaxTerm staTaxTerm ON
(VendorJobs.TaxTerm = staTaxTerm.TaxTermID)) INNER JOIN staTravelReq staTravelReq ON
(VendorJobs.TravelReq = staTravelReq.TravelReqID)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
