datoshway Posted November 10, 2011 Share Posted November 10, 2011 I'm not sure why i'm getting duplicate results with this query, any ideas by the look of it? $strQuery = "SELECT d.intCityID, d.strClinicDate, c.strName, c.boolPastEvent, c.boolClosed FROM tblCitiesDates d LEFT JOIN tblCities c ON d.intCityID = c.intID ORDER BY d.intCityID ASC"; Link to comment https://forums.phpfreaks.com/topic/250816-need-help-with-a-unique-query/ Share on other sites More sharing options...
datoshway Posted November 10, 2011 Author Share Posted November 10, 2011 Nevermind I got to the bottom of it. Just needed group by c.intID Link to comment https://forums.phpfreaks.com/topic/250816-need-help-with-a-unique-query/#findComment-1286876 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.