join on json field

Solutions on MaxInterview for join on json field by the best coders in the world

showing results for - "join on json field"
Anton
24 Jan 2021
1  SELECT 
2       user.user_id, 
3       user.user_name, 
4       user_group.user_group_id,
5       user_group.group_name
6   FROM user
7   LEFT JOIN user_group on JSON_CONTAINS(user.user_groups, CAST(user_group.user_group_id as JSON), '$')
8