I have the tables (and their relationships) in the diagram below:
I need to do the following: Bring all the fields of the TBCADCRE table and an extra column named ADQ with all the TIPADQ that the user has (can have a maximum of 6) separated by ",".
To improve understanding, I made a select with the 3 tables, but it returns one line for each TIPADQ that the user has (image below).
IneedtobringasinglelineandallTIPADQswithinthesamefieldseparatedby",". Ex: SKY, STONE, POS ...
Can anyone help me? Thank you.