I'm not sure if this is remotely what you want, but have you checked out querysim? It just seemed vaguely like what you're looking for even though I've missed this entire conversation.
http://www.cflib.org/udf.cfm?ID=255 Mike Ian Skinner wrote: > select 'red', 'green', 'blue' from dual > > I'm wondering if that will work for you, just as a subquery for your join.. > > Won't that create three columns named "red", "green" and "blue?" What I need > is a single column "Color" with three rows each with a value of one of the > list items so that I can outer join that record set against the other record > set. > > PS. I came up with a way to due it in CF. I loop over the list doing a > query of a query against a query of the second table. I then dynamically > build a query object combining the list and query of query results. > > It works, but I would still be interested in an Oracle "Internal" solution if > one exists. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229708 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
