For mySQL: SELECT CONCAT(t1.id,'=', t2.id) AS newstring FROM table01 t1 INNER JOIN table02 t2 ON t1.id = t2.id
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 2:17 PM To: CF-Talk Subject: SQL concat? help I'm trying to do a query that should go something like Select someid, (select concat(someotherid) from anothertable where anothertable.someID=mytable.someid) from mytable Basically I want a query that brings in someID and for each of those a list of ID's from another table. Is this possible? I think I remember doing a query like this a long time ago, but can't remember the exact syntax. Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
