Thanks for all your help on that one guys :) All working now.
On 2 Nov 2005, at 19:36, Hassan Arteaga wrote: > Hi Stuart > > Try "Inner Join" with the key in each table > > IE: > > Imagine u have two tables Basket and basketDetails in an ecommerce > application > > SELECT * > FROM _C_Basket INNER JOIN > _R_BasketDetails ON _C_Basket.idBasket = > _R_BasketDetails.idBasket > > In this case idbasket is primary key in _C_Basket ... > Regards > __ > M.Sc. Hassan Arteaga Rodríguez > Microsoft Certified System Engineer > IT Specialist > DIGI Grupo de Desarrollo. COPEXTEL, S.A. > > Este email y sus adjuntos está dirigido solamente a los destinatarios > consignados en el mismo y debe ser considerado confidencial. Si Ud. > no es el > destinatario consignado o la persona responsable de entregar/enviar el > presente, no podrá copiarlo o entregarlo/enviarlo a ninguna otra > persona ni > utilizar el mismo en forma no autorizada. Dichas acciones están > prohibidas y > pueden ser consideradas ilegales. Si Ud. recibiese este email por > error, por > favor comuníquelo de inmediato al emisor del mismo. > > -----Original Message----- > From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 02, 2005 12:56 PM > To: CF-Talk > Subject: SQL distinct > > > 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:222959 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
