that is because you are getting the event details as well e.eventID and e.userID if you remove these from the select list and put the DISTINCT back that should do the trick. Mike T
On 11/2/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote: > > Hi guys, > > I'm trying to do something simple but having a bit of a bother. > > <cfquery name="GetUsers" datasource="user020"> > SELECT u.userID, u.firstName, u.lastName, e.eventID, e.userID > FROM tbl_020publicUsers u, tbl_020eventDetails e > WHERE u.userID = e.userID > </cfquery> > > I'm trying to get a list of all the users in table tbl)020publicUsers > which have a record in the table tbl_020eventDetails. However, I > keep get multiple listings for the users who have multiple rows in > tbl_020eventDetails. I did trying adding the word DISTINCT after > SELECT but it didn't do anything. > > Any help would be gratefully appreciated. > > Thanks, > > Stuart Kidd > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
