topic Re: retrieve data from multiple tables without in App Development

retrieve data from multiple tables without

g_larosa — Sat, 16 Nov 2024 06:50:21 GMT

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 ?

Giuseppe

Re: retrieve data from multiple tables without

Gysbert_Wassenaar — Wed, 16 Jan 2019 16:06:21 GMT

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;

Re: retrieve data from multiple tables without

g_larosa — Thu, 17 Jan 2019 14:41:26 GMT

Hi ,

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

br
Giuseppe