Skip to content

Instantly share code, notes, and snippets.

@RelativeTech

RelativeTech/select-from-where-2.sql

Created March 25, 2021 20:38
Show Gist options
  • Save RelativeTech/28e0c1a3d13e58713f2ad3f01e0d25d1 to your computer and use it in GitHub Desktop.
Save RelativeTech/28e0c1a3d13e58713f2ad3f01e0d25d1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select-from-where-2.sql
select p.project_name, w.worker_name
from project p, worker w, project_worker_map m
where m.project_id = p.id
and m.worker_id = w.id
order by worker_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment