Help Merge two tables by the column variables

Hi,

I have the following table tComplete, where there are 50 different Birds, 2 Days (P and O), different Tries, and 200 Features per Try.

Then, I have the following table tProfile, where there are some of those 50 different Birds, 2 Days (P and O), different Tries, Scale and Fly information per Try.

I want to:

1. Add the Features 1 to 200 (column 4 to end of tComplete) to the end of the tProfile table. To do this I need help to check the Bird, Days, Try of the tComplete table to match the tProfile one. In the end we have the Features for the specific rows of tProfile.

Thank you!

Answer 1

[Peter Perkins]

See join (or maybe innerjoin).