HELP WITH JOINING 5 TABLES

5 pts.
Tags:
Microsoft Excel
Microsoft Excel table
I need to join 5 tables and the probelm is that I have imported 5 seperate excel spreadsheets and the first column in all the spreadsheets is the same and I need to combine all that data to see if there are any duplications throughout the 5 spreadsheets and then combine some data that may be the same from other columns???

Answer Wiki

Thanks. We'll let you know when a new response is added.

To find the rows which exist in all 5 tables use the INNER JOIN syntax to join them all together.

<pre>SELECT t1.id
FROM t1
JOIN t2 on t1.id = t2.id
JOIN t3 on t1.id = t3.id
JOIN t4 on t1.id = t4.id
JOIN t5 on t1.id = t5.id</pre>

To see which rows exist in two of the tables only join those two tables together.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following