Skip to content

Instantly share code, notes, and snippets.

@RelativeTech

RelativeTech/work_id.sql

Created March 25, 2021 20:39
Show Gist options
  • Save RelativeTech/b963a85584a988cb9a015091d023ebbf to your computer and use it in GitHub Desktop.
Save RelativeTech/b963a85584a988cb9a015091d023ebbf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
work_id.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
and m.worker_id in (
select id from worker where worker_code in('CODE-1', 'CODE-2')
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment