I have 2 spreadsheets with related data

spreadsheet1:
code data1
1 asd
2 qwe
3 zxc
etc (very long list... with several more columns...)

spreadsheet2:
code data2
1 poiu
3 lljh
etc (list can be short, with more columns, and updateable) all codes in
spreadsheet2 ARE included in spreadsheet 1

is there a way to append this data, so that it will show something like:

code data1 data2
1 asd poiu
2 qwe
3 zxc lljh