Programming

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