Skip to content

Instantly share code, notes, and snippets.

@kimberlyh66

kimberlyh66/inserts_citations_sites_season_6.sql

Created January 16, 2019 21:27
Show Gist options
  • Save kimberlyh66/b1fe6219cc8914a5e5553f7be3c2312a to your computer and use it in GitHub Desktop.
Save kimberlyh66/b1fe6219cc8914a5e5553f7be3c2312a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
inserts_citations_sites_season_6.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 = 2018) as c cross join (select id as site_id from sites where sitename like 'MAC Field Scanner Season 6%') as s;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment