How to merge 2 sheets in Google Spreadsheets by common parameter?

Question

Google Apps Script

There are 2 tables on 2 sheets. Each has a column with a list of id, which are repeated in 2 tables, the rest of the columns are different. It is necessary to bring 2 tables into one by these id.
So far, I have found a way to do this only using the Google Spreadsheets extension, but you can use it for free a limited number of times and there are a number of other disadvantages.
Perhaps there is a way to do this with scripts/formulas/regulars?

Answer 1

Yes, this can be done with scripts. If you don't want to deal with Google Apps Script, then find a freelancer.

Answer 2

You can use Vlookup + Query (rougher solution but free)