Solved

Relationship between 2 tables (left outer join)

  • 12 January 2022
  • 1 reply
  • 93 views

When I have two tables, how can i make a left outer join between 2 tables. Or do i always need to use a custom view for this situation. 

Table 1 = Adress
id = 1
id = 2

Table 2 = Relation
personid = 1
personid = 2

Table 3 
id = 1, personid = 1, personid = 2
id 2 , null

icon

Best answer by Thomas Lind 13 January 2022, 15:43

View original

1 reply

Userlevel 5
Badge +5

Hi Roland

Yes. All lookup fields are a inner join. So a lookup field will not add more rows to the table than already exists in it.

You can add more rows to a table with a table insert or a add related records feature.

Normally I would create a custom view to split out tables.
It is also what I explain in my views guide.https://legacysupport.timextender.com/hc/en-us/articles/115001394043-Exploding-tables-using-views

Reply