Ok, I got the Union thing down pat and working 100%. Now I got 4 columns
with "related" information that needs to be added together, then display the
Top 10.
To summarize what i am wanting to do. I got 2 tables with the same field
types/names. I want to be able to connect to the two, add up the 4 fields of
information then list the Top 10 TOTALS from the 2 tables combined.
Any ideas.
I got the joining part down, thanx to this newsgroup :)
<CFQUERY NAME="NameMe" DATASOURCE="SomeDNS">
SELECT LastName, FirstName, Beard1, Beard2, Beard3, Beard4,
HarvestCounty
FROM Table1
Union
SELECT LastName, FirstName, Beard1, Beard2, Beard3, Beard4,
HarvestCounty
FROM Table2
</CFQUERY>
______________________________________________________________________
Dedicated Windows 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=coldfusiona
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
