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
Best answer by Thomas Lind
View original
+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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
