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"; Quote Link to comment 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 Quote Link to comment 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.