Thank you ... I realized this after I sent out the message ... I was looking at the whole thing backwards making things more difficult than they were ... thank you!
Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 3:25 PM Subject: RE: Getting single records with multiple records from a join > SELECT > c.id, > c.first_name, > c.last_name, > c.email, > cy.year > FROM crew c, crew_years cy > WHERE c.id = cy.crewid > > > <cfoutput query="thequery" group="id"> > #first_name# #last_name#: <cfoutput>year,</cfoutput> > </cfoutput> > > > You'll want to use the outer join syntax that was provided the other day if > you want to grab people without any years associated with them. > > Adam. > > > > > > -----Original Message----- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 22, 2002 3:19 PM > > To: CF-Talk > > Subject: OT: Getting single records with multiple records from a join > > > > > > I am getting users names from one table and joining the years > > they have been with us in another. How would I join the two > > together and ouput the years (1995,1996,1997) along with their name. > > > > Here are the tables: > > > > crew > > =========== > > id, first_name, last_name, email > > > > > > crew_years (crewid = id from the crew table) > > =========== > > crewid, year > > > > My outcome would be something like: > > > > John Doe Years: 1999,2002,2003 > > Mary Doe Years: 1995,2000,2001 > > > > ect.. > > > > TIA > > > > Paul Giesenhagen > > QuillDesign > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists