Skip to main content

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

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