It seems database blocks creates left joins. Is there an easy way to have it use a right join for certain queries? I guess the easiest way would be to just use a custom query.
Also a related question: Is there a way to keep cf from caching a specific query? Mark ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
