cluelessnoob Posted January 31, 2009 Share Posted January 31, 2009 I need help with this join. Any ideas what I'm doing wrong. SELECT facName.facility,facAddress.facility, CONCAT(facCity.facility, ', ', facState.facility) AS loc, facZip.facility,refRateID.Urating,refFID.Urating,RateID.Ratetype,RateType.RateType FROM facility,Urating,Ratetype WHERE (facZip.facility = '$zip' AND refFID.Urating = FID.facility AND refRateID.Urating = RateID.RateType) LIMIT $start, $display"; Quote Link to comment https://forums.phpfreaks.com/topic/143227-three-table-join/ Share on other sites More sharing options...
ultrus Posted February 1, 2009 Share Posted February 1, 2009 Some of your query looks backwards. it should be columnName.columnValue: facName.facility,facAddress.facility, CONCAT(facCity.facility, ', ', facState.facility) AS loc should probably be: facility.facName,facility.facAddress, CONCAT(facility.facCity, ', ', facility.facState) AS loc That's just a small part of it, but I hope that gets you started. Quote Link to comment https://forums.phpfreaks.com/topic/143227-three-table-join/#findComment-751751 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.