i have one table called visao with somes problems from the day:
and i want to do this:
create another table called days, with three columns: (data - list - sent).
and the value from column List - (i want to get all the values from table visao, if the column solucao is equal testeA), but only two column from there - maquina and problema)
so in this example, the values to column List it will be:
my only problem is its possible to column list get this rows from another table. but it will be only in one row like this: