Another good reason to at least stay friendly with table aliases is that they can provide for very powerful subqueries. They may look weird but they are very nice when you get to know them.
On 2/6/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Jeasus man! I'm gonna show you something, it'll take me about an hour to > rewrite your query though!! Bare with me... [snip] -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

