I have two tables: server_and_server_servername. If you require more than one technician for an O.S., records of each technician are created in the second table listed by the order number (id).
I would like to make an open order query that would show the technicians related to it.
SELECT
os.numero_os AS numero_os
FROM
ordem_servico os
WHERE
os.data_servico BETWEEN '$data_cad_i' AND '$data_cad_f'
With subquery gave the error: "Subquery returns more than 1 row" because it actually has more than one technique for the same O.S ..