What didn't work with the second set of queries? Did you get an error message? That logic is sound. There might be some syntax issues as I didn't test it...
Dave -----Original Message----- From: Barry Mcconaghey [mailto:bmcconag...@gmail.com] Sent: Monday, February 15, 2010 10:28 PM To: cf-talk Subject: Re: Total Two Field From Two Tables Hi Dave. Thanks for the code! Those two did not work. I got two queries to work perfect but I don't know how to display them. <!---Get all data---> <cfquery name="Story" datasource="#request.dsn#"> SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev FROM fddirectory F, states S WHERE F.fdd_state = <cfqueryparam value="MD" cfsqltype="CF_SQL_VARCHAR"> AND F.fdd_state = S.abrev ORDER BY fdd_name </cfquery> <!---Count each fdd_name---> <cfquery name="Zip" datasource="#request.dsn#"> SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS FDCount FROM articles a, fddirectory f WHERE a.zipcode = LEFT(f.fdd_zip, 5) AND f.fdd_state = <cfqueryparam cfsqltype="cf_sql_varchar" value="MD"> GROUP BY f.fdd_name ORDER BY f.fdd_name ASC </cfquery> <!---Display---> <cfoutput query="zip"> #fdd_name# (#NumberFormat(zip.fdcount)# <br> </cfoutput> This works great but it only displays fdd_name when a.zipcode = LEFT(f.fdd_zip, 5). I would like to display something like this: <cfoutput> <!---Display all fdd_name---> #story.fdd_name# <!---Display this if GT '0'---> (#NumberFormat(zip.fdcount)# <br> </cfoutput> Thanks for your time. Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330763 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
