Try with: <cfquery name="query1" datasource="your_dns"> select [fields u want] from table1 Union select [fields u want] from table2 </cfquery>
Bye Gianluca Pinelli ----- Original Message ----- From: "Webmaster" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 11, 2002 6:21 AM Subject: Comparing two fields from two tables > I have two tables with identical fields. Now I want to extract the top 10 > scores from both tables. I want to know how to query the two tables, t hen > compare the values to find the top ten scores from them. > > Any help would be GREATLY appreciated. > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
