Is there a way to get all values associated with foreign key joined in a tuple?

Asked Jun 01 '17 at 10:21

Active Jun 01 '17 at 12:20

Viewed 41 times

I use a relation looking like :

In Mysql.

NB:

clientss 1..N evenements_clients

evenements_types 1..N evenements_clients

Or, if I got it wrong again,

1 client can have many evenements_clients

1 evenements_types can have many evenements_clients

And I'm looking for a way to join evenements_types such as I get a tuple like

Considering EtCode equals EvType

ClNum, ClNom, EtCode1, EtCode2, EtCode3, EtCode4 ... (as many as there are)

and not vertically

ClNum, ClNom, EtCode1
ClNum, ClNom, EtCode2
ClNum, ClNom, EtCode3
ClNum, ClNom, EtCode4

I used Phpstorm to generate the image.

edited Jun 20 '20 at 09:12

Community

asked Jun 01 '17 at 10:21

You should investigate the query clauses `GROUP_CONCAT(EtCode) ... GROUP BY` – O. Jones Jun 01 '17 at 11:29
Ah, found something thanks to you. – Pierre-Antoine Guillaume Jun 01 '17 at 11:37
Bear in mind you're seriously bending the rules of relational DB design and usage here. Great if it works for you in the odd one-off situation but if you find yourself doing it a lot, you probably need to rethink what you're doing, especially if the tuple itself has variable columns as opposed to a single separated value. – LoztInSpace Jun 01 '17 at 12:48
Yeah, I kind of realised that. I'm going to stay with group concat I suppose. – Pierre-Antoine Guillaume Jun 01 '17 at 13:27

0 Answers0