user functional test for joins added