Skip to content

Instantly share code, notes, and snippets.

@amberlex78

amberlex78/many-to-many

Last active April 7, 2024 15:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save amberlex78/8126cff7a6c8330938fc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save amberlex78/8126cff7a6c8330938fc to your computer and use it in GitHub Desktop.
Download ZIP
SQL many-to-many (users of task)
Raw
many-to-many
SELECT * FROM `tasks2users`
JOIN `users` ON (`tasks2users`.`user_id` = `users`.`id`)
JOIN `tasks` ON (`tasks2users`.`task_id` = `tasks`.`id`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment