Topic: Request about the total of an ode a line
Good afternoon. Help, please, about request.
There are two tables: the nomenclature and requests.
nom_id | nom_type
1 | salon
2 | a luggage carrier
req_num | req_qty | nom_id
25 | 5 | 1
25 | 3 | 2
As to me to receive the total single line (but in two columns) under the request table that in one column there was a total of salons, in other column the total of luggage carriers under one request.