retrieve data from multiple tables without

[g_larosa]

I have the following tables on Data Manager:

TABLE A
NAME	FIELD1	FIELD2
a
b
a

TABLE B
NAME	FIELD1	FIELD2
a	3	x
b	2	x
c	4	x
a	3	x
a	3	x

and I need to make App with a table C like this:

TABLE C
NAME	A.FIELD1	A.FIELD2	B.FIELD1
a	x	x	3
b	x	x	2
c	x	x	4

when B.FIELD1 is the first a.name occurency on table B. How can I do it without Associations ?

BR

Giuseppe

[Gysbert_Wassenaar]

Join the tables:

TableA:
LOAD NAME, FIELD1 as A.FIELD1, FIELD2 as A.FIELD2 FROM source_table_a;

LEFT JOIN (TableA)

LOAD NAME, FIELD1 as B.FIELD1 FROM source_table_b;

[g_larosa]

Hi ,

it doesn't work, maybe because it's a many to many association

br
Giuseppe