Finished basic join api.