Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
could you please help me with this issue.
i have two tables
table1:
ID | A | B |
---|---|---|
1 | 20 | 60 |
2 | 30 | 25 |
4 | 10 | 11 |
TABLE 2:
ID | A | C |
---|---|---|
3 | 33 | 50 |
5 | 30 | 43 |
6 | 21 | 26 |
AND I NEED THIS
ID | A | B | C |
---|---|---|---|
1 | 20 | 60 | |
2 | 30 | 25 | |
3 | 33 | 50 | |
4 | 10 | 11 | |
5 | 30 | 43 | |
6 | 21 | 26 |
THANKS!
gerardo
Hi
concatenate between two tables
if the field name is same in both the tables
id in both the tables
if ur result is like
t1.id,t2.id --
for this use the unqualify
or
use alias to change ur field name to id