After reading through the article I got the impression that the author was trying to show how to write queries in MySQL syntax to return the same results as intersect and minus...(I tried both intersect and minus and they threw MySQL syntax errors)
Going to try the alternative he proposed now. -----Original Message----- From: andy matthews [mailto:[email protected]] Sent: Sunday, October 03, 2010 3:22 PM To: cf-talk Subject: RE: Can't figure out a query to accomplish this... Appears that MySQL does support intersects, or minus like Greg suggested. http://www.bitbybit.dk/carsten/blog/?p=71 andy -----Original Message----- From: Greg Morphis [mailto:[email protected]] Sent: Sunday, October 03, 2010 2:18 PM To: cf-talk Subject: Re: Can't figure out a query to accomplish this... Does MySQL support 'minus'? On Oct 3, 2010 2:12 PM, "Rick Faircloth" <[email protected]> wrote: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
