You can combine queries from multiple tables by using the Query of Query feature (which we discussed at the meeting last month). Change your opening to a query to cfquery name='newQueryName' dbtype='query'
Then reference the previous queries as if they were table names, i.e. use the query name from before as a table name. Keep in mind that QofQs will only let you combine 2 queries at a time. Useful for combining data from say, Oracle & SQL, or 2 separate SQL databases where you can't join the data directly. Consider using UUID/GUIDs for your primary keys on the child and parent tables. If you are using numerical identity columns in each of the 3 tables, you may experience problems with records being in each table with the same primary key. ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To subscribe or unsubscribe, send an email to [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
