For JOIN documentation, please refer to the Wiki