topic How to join data in App Development

How to join data

Sra1bandi — Tue, 14 Mar 2023 10:01:21 GMT

Hi team

i have 2 tables

Table 1:-

Code Id

1 11AC

2 BR25

3 A810

Table2:-

Key Id Username

1 11AC Raju

1 11AC Vamsi

1 11AC sai

I need to show the table like below

Required Output Table:-

Key Id Username

1 11AC Raju

1 11AC Vamsi

1 11AC sai

2 BR25 -

3 A810 -

When i am trying to do left join i am getting result like all user names are assigning for each id but i need to show usernames only for ID= 11AC three usernames.

Regards,

Sravan.

Re: How to join data

Marijn — Tue, 14 Mar 2023 10:17:29 GMT

Hi Sravan,

I'm not sure what you need exactly, but from the example this should do the trick.

main_table: load * resident table2; outer join (main_table) load Code as Key, Id resident table1; drop tables table2,table1;