summary SurrealDB's relational style joins exist in a superposition. The only way to know for sure is by looking at this blog post. SurrealDB doesn't do traditional SQL joins. What we have instead ...
This example illustrates a left outer join of the PROCLIB.PAYROLL and PROCLIB.PAYROLL2 tables. proc sql outobs=10; title 'Most Current Jobcode and Salary Information'; select p.IdNumber, p.Jobcode, ...