@Jörg,

Would you please provide an example where it produces a virtual table. If that was possible, I would think you could use it in the View layout element or the function itself would return something similar to that. As far as I know, the join() function returns a string and you use it in a Formula field. To mimic an Inner Join I had to code it something like this...

replace(join(for i in select Table1 do
join((select Table2 where T2Text = i.T1Text).(T2Text + "  " + Number), "
")
end, "
"), "

", "
")

I had to use the replace() function to remove the linefeed created for no matching records.

I think the View layout element would be perfect for implementing the various JOINs.

Who said anything about the tables being related? If you want a list view instead of a table view, then the solution I posted using the join() function in a formula field will work. Here's a diagram of the various JOINs, which one are you referring to?