INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Join multiple tables

Join multiple tables

(OP)
I keep being told that I have too many tables. How can I join them? Most of them have fields named the same. Could I join say 24 tables together and add a field that shows the name of the table each record originally came from?

I didn't understand it at first but now I see how this would be more efficient.

Each table has a different name so i'd like a field with the name of each table as i need to be able to differentiate between my records in this way.

RE: Join multiple tables

Normally it requires adding a field.  
Assume you have tables of customers, suppliers, employees.

Each of these tables has first name, last name, MI, telephone, email.

this can be one table, "tblPersons".  You can then add a field personType with values of Customer, Supplier, Employee.  If you want to see/work with just the employees you query the table "where personType = 'Employee'".

If these tables have a lot of fields in common, but also a lot not in common then you may not want a single table.

RE: Join multiple tables

FYI, the term is not "Join", that means something else in database lingo.  You want to "merge" records into a single table.  Also this can be automated through SQL through either an "append" query or "make table" query.  You will not have to copy/paste or do any of this manually

RE: Join multiple tables

(OP)
Hey,

The time difference is a real pain between here and America! I successfully merged the tables. Took a while but i've it done!

Thanks anyway.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close