inventory calulcation

i have table a and table b table a has qty and itemnames table b has qty and itemnames and yes/no

i need to display all the itemnames in table a and sumtotal of qty of table a and table b if table b column is yes