Need help with new column

[thrdelja]

Hello.

I have a two tables who have two same column with same information, but one have column Price, and one Quantify. I need the column Price add in table 2 where I have Quantify. How to do it? Thanks a lot.

 

[StefanoGrimaldi · Accepted solution]

use the merging option: 

select the key column in each table and them you expand the column you want to add, 

if this helped please give some kudos, if it solved your question mark it as solution for others to find.