Hi all,
I would like to display more values of different tables in one row. The issue is that I want to display more values from the same column!
exp.
Table1
id | col1
----------
1 val1
2 val2
Table2
id | col2
-----------
1 val2
2 val3
3 val4
My goal:
Table1.id-A Table1.col1-A Table1.id-B Table1.col1-B Table2.id-A Table2.col-A ......
1 val1 2 val2 1 val1 2 val2 3 val3 ........
Any idea? Thanks in advance!
Where did the (id, column) pair of (3, val3) come from ? It isn't there either in Table1 or Table2.
The tuples (1, val1) and (2, val2) are in Table1. Do you want them repeated like you've shown above ?
I don't see "id-A", "id-B", "col1-A", "col1-B" anywhere in the sample data you provided.
Which database ? What database version ?
tyler_durden
No I don't want to repeate the entries, I just want to show all enties in one row(line).
I mean the diffenet values in one column wit the char: (-A, -B ...) "But the columns names is not important from my point of view!
The Mysql version is 5.0