You could do a query of queries. You dynamically create a query result set that has your aDate values (cfloop over the range, and add a new row and value on each iteration). Run a query of your actual db table limited to the dates in question. Then run a query of queries where you do a join (I never remember my terms...left outer?) where it's all rows from the generated aDate query set and matching values from aTable. I can't remember if you can do outer joins in queries of queries, but I think this would work.
HTH, Matthieu That would probably work to solve the problem as I presented it. But the problem I was trying to solve is that I join several tables against the key value and I need them to show up whether the first value exists or not. Trouble is that I can not guarantee any table in the set will have a complete range of values to join against. A more complete example: Table1 Key Letters --- ----- 1 A 3 B 5 C Table2 Key Colors --- ------ 1 Blue 2 Green 3 Red Table3 Key Names --- ----- 3 Joe 5 Sam The result set I'm looking for with a range between 1 and 5 should look something like this: Key Letters Colors Names --- ------- ------ ----- 1 A Blue NULL 2 NULL Green NULL 3 B Red Joe 4 NULL NULL NULL 5 C NULL Sam -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223060 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
