mysql join with multiple values in one column
- by CYREX
I need to make a query that creates 3 columns that come from 2 tables which have the following relations:
TABLE 1 has Column ID that relates to TABLE 2 with column ID2
In TABLE 1 there is a column called user
In TABLE 2 there is a column called names
There can be 1 unique user but there can be many names associated to that user.
If i do the…