merging two colls into one

access United States
  • 13 years ago


    is there a way to merge two cols in to one?


    this is how my data looks:

    Name               Second_Name


    Ron                   Dan

    Dan                   Mike

    Linda                 Dan

    Sean                 Ron

    Karen                Dan

    Dan                  Jane

    Ron                   Dave


    what i want to do is merge all of Dan's second names (only where Dan appears as either a first name or a second name) to one single collum

    so it will look like that:










    all of those are  Dan's other name

    I tries to create one SELECT inside the main SELECT but still it gave me two collums aventually.

    anyone has an idea?

    thank you.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The most exciting phrase to hear in science, the one that heralds new discoveries, is not 'Eureka!' but 'That's funny...'” - Isaac Asimov