Cross-referencing two data tables

Cross-referencing two data tables

I hav two sheets that I am going to want to cross-reference (hopefully by using an SQL chart)...

Sheet 1: Already, I have a sheet that I built with User ID #s and some resulting scores data.

Sheet 2: I have a .csv coming from an outside provider that will have matching User ID #s in a column, but the data categories are different.

I watched the video on how I can use the SQL interface to make a display sheet, but I want to cross-reference the two sheets I mentioned above (Sheet 1 & 2) so that I can view all datasets by ID number... Essentially, I want to combine the sheets without having to manually match the ID numbers, add new columns and data-enter each of the new data categories that are being sent in from Sheet 2. 

Where do I start?  Help is much appreciated.  Love the product; need to learn the 'languages'.