If both tables are in the same data source you can use a UNION to combine the results.
--- Ben -----Original Message----- From: kaigler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 5:29 PM To: CF-Server Subject: joining output from 2 queries Has anyone tried to join 2 different outputs. I have 2 different tables. data is similar but field names are different. Is it possible? example table 1 field1 = Bill Kaigler field2 = programmer table 2 name = Jane Doe occupation = physician The more I think about it I think I will have to do the 2 queries, output to an array and then display the array..... any other ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
