Hi @Tom Parker?
I really like your workaround for doing a cross join. I had similar thought but never actually tried it out yet. 👌
However, I'd think you need to change the order of the conditions so that the actual join is the first condition:
Select table_a.id, table_b.id
from table_a, table_b
where table_a.crossjoin_id = table_b.crossjoin_id
And CartesianObjectDistance(table_a.obj, table_b.obj, "m") <10
into joined_points_10m?