I have three tables:
ESCRITORIOS
id
nome
ESCRITORIOS_SEGMENTO
id_escritorio
id_segmento
SEGMENTOS
id
nome_segmento
What I need is to give a SELECT to list this information as well
SEGMENT BLABLA:
desk 1, desktop 2
BLIBLI SEGMENT
Desk 1, Desk 4
BLOB SEGMENT
2, desk 3
BLUBLU SEGMENT
desktop 3
I tried in many ways, with LEFT JOIN, GROUP, but it did not roll ....