I want to bind two tables A and B, just show the same number of fields in both tables, Example:
Table 1
Column A Column Y Column W Column N Column G
Table 2
Column A Column W Column J Column G Column N
In SQL Whould be displayed:
"Select
Columna A Columna W Columna N Columna G
From Tabla 1
Union All
Select
Columna A Columna W Columna N Columna G
From Tabla 2"
Result = Columna A Columna W Columna N Columna G
I want to do this in the jet report.
Hello Francisco.
Have you tried the Jet Table Builder?
In what way are Table 1 and Table 2 related?
I have the same need as Francisco. Does anyone have an answer to the question above.
.
Hello Stacy.
I have the same questions for you that I had for Francisco:
Have you tried the Jet Table Builder?
In what way are Table 1 and Table 2 related?
The tables aren't related. That's why you would use a UNION for the two tables. No I haven't used the Jet Table builder. An example is below:
select salesid, customerAccountNo from salesline
UNION
select invoiceID, AccountNo from custinnvoice trans
Would return:
SO001
SO001 CUS001
INV001 CUS489
.....
