You can also join two query results together that are different using a query of a query in CF5.0.
Don't forget that your fields widths must be the same in UNION's, so if one is longer, trim it appropriately in the SELECT statement. Alexis Graves -----Original Message----- From: kaigler [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 9:51 PM To: CF-Server Subject: RE: joining output from 2 queries 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? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
