JMP Query Builder (Tables > JMP Query Builder) is missing a key functionality, allowing right and full outer joins. See this techical note: https://www.jmp.com/support/notes/59/817.html
It would be good to add the ability to do these types of joins with the JMP Query Builder. This capability does exist, I know, with Tables > Join, but for those who want to use an SQL approach for table joining, this is an important capability to have.