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:229707 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
