Table Joining

Question

Hi all,Im a newbie here and Iam making a windows application in which i imported a datagridview .I want to join two tables by asigning a primary key.The problem here is that i need to calculate amount of whole transaction by multiplying two columns...and giving it to the last column...Hope you understood the problem for now.