SELECT with intermediate table returning all values in the same field and separated by commas

1

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.

    
asked by anonymous 23.08.2018 / 23:39

1 answer

1

After several attempts and errors, I resolved as follows:

    
24.08.2018 / 18:19