You can also do some basic joins <cfquery name="comps"> SELECT compId, compName FROM comp </cfquery>
<cfquery name="users"> SELECT userId, compId, userName FROM user </cfquery> <cfquery dbtype="query"> SELECT comps.compName, users.* FROM comps, users WHERE comps.compId = users.compId </cfquery> Cheers Mark ______________ Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
