Matthew Walker wrote: >This (http://www.pcreview.co.uk/forums/thread-1138891.php) seems to suggest >that UNION ALL might be your answer. >
Thanks, that worked. The full field is displayed now. The ALL parameter would show repeated records, but since in my case both tables are mutually exclusive (i.e., if the records are pulled from one table they are not pulled from the other) then there wouldn't be repeated records. Taco, I'd like to explore your CASE option further, but the more I read on CASE the less clear it is to me what the syntax could look like. Care to post a more complete example? Thanks all, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212358 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
