Skip to content

Instantly share code, notes, and snippets.

@kimberlyh66

kimberlyh66/inserts_citations_sites_season_5.sql

Created January 17, 2019 19:18
Show Gist options
  • Save kimberlyh66/16f94f080fdb176d430dcb85998e175a to your computer and use it in GitHub Desktop.
Save kimberlyh66/16f94f080fdb176d430dcb85998e175a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
inserts_citations_sites_season_5.sql
insert into citations_sites (citation_id, site_id)
select c.citation_id, s.site_id
from (select id as citation_id from citations where author = 'Newcomb, Maria' and year in (2017, 2018)) as c cross join (select id as site_id from sites where sitename like 'MAC Field Scanner Season 5%') as s;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment