On 07/19/2005 10:12 PM Mathew Walker wrote: >I'd go with a UNION. The reason a union is useful is that you want B.content >and C.content to appear as the same column in your record set, which is what >a union does well.
Thanks for your answer. I tried the UNION and it did what I wanted (it pulled the "content" field from either the B table or the C table based on the value of the 'status" field in the A table). However, when I output the "content" field with: CFOUTPUT #QueryName.content# /CFOUTPUT .....the output shows only the first 255 characters of the "content" field (the maximum length for an Access text field), although the field is set to "memo" in both tables B and C. Can this be fixed, or is it a limitation of UNION? Thanks, 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:212346 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
