add join to API