What type of join do wish to do? Do you have any columns you can join with? Or is it just row by row? If query builder isn't able to do what are looking for, you might have to do this by scripting Join platform (luckily it is simple but still it will require a script). If it is always the same join with the same amount of tables, you can most likely do this with the help of Workflow builder.
@mzwald do JMP tables support full outer join? https://www.jmp.com/support/help/en/18.0/index.shtml#page/jmp/select-tables-from-a-sql-database.shtm...
To do a full join and import all rows, you would select Include non-matching rows from g1_charges. If only one of the non-matching options is available, the database does not support full joins.
Would be nice if query builder was able to tell what the gray-out means instead of leaving user guessing what they are doing wrong
The gray-out "option" can only be activated for Database queries:
When you want to build a query from JMP data tables:
the option is always disabled:
If you need this option you can ask a community manager to reactivate this wish:
... and vote for it.