thanks Ben. I actually remember reading an article you wrote about this. I searched my office for the magazine and could not find it. This is enough information to get me there.
thanks kaigler At 05:28 PM 11/13/2001 -0500, you wrote: >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
