We need the capability to join documents natively in a view in the notes client with out the need of DB2.
I suggest the following syntax:
[ FULL | INNER | OUTER ] [ LEFT | RIGHT ] JOIN left_selection_formula [ALIAS "fieldname1" AS "aliasfieldname1", ALIAS "fieldname2 AS "aliasfieldname2", ... ] TO right_selection_formula [ALIAS "fieldname3" as "aliasfieldname3", ... ] ON @JoinLeft(left_formula) = @JoinRight(rightformula)
@JoinLeft and @JoinRight are formulas that cause the formula in the parameter to act upon their respective document, and should be usable in selection, column and action button formulas.
LoutsScript NotesViewEntry class should also be extended with a LeftDocumentUNID and RightDocumentUNID or equivalent.