lubnafarhi
Newbie level 1
I want to add fields from one column and display them in anothher table's field for which there needs to be similarity in the fields. For example, I want to create a query that will show the total bill in the total bill field in the transaction table by adding all the total item cost fields for the same transaction id in the transaction detail table.