Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there. Can you help me to connect 2 tables with Loop row by row.
| T1 |
|---|
| A |
| B |
| C |
| D |
| E |
| F |
| T2 |
|---|
| 15 |
| 32 |
| 52 |
| 55 |
| 21 |
| 7 |
There is no keyword for 2 tables. I just want that row1 to row1, row2 to row2...
| T1 | T2 |
|---|---|
| A | 15 |
| B | 32 |
| C | 52 |
| D | 55 |
| E | 21 |
| F | 7 |
I have too many rows. So I wll not use inline table.
Thank you.
Try this:
Data:
Load
RecNo() As No,
T1
From Table1;
Join
Load
RecNo() As No,
T2
From Table2;
Result Table will have No, T1, T2 fields. You can drop No field by command
Try this:
Data:
Load
RecNo() As No,
T1
From Table1;
Join
Load
RecNo() As No,
T2
From Table2;
Result Table will have No, T1, T2 fields. You can drop No field by command