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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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