G Money wrote: > How so? > > I still don't think he's going to get the values in a list form in a single > column using just SQL. > > On 9/12/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > >>left outer join would have worked better
left outer join would not have worked at all. Try it. simple joins (outer, inner, etc) would return multiple rows of data for each individual person. It would *NOT* combine the multiple locations into a single field. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:215205 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5