update List the collections in the current schema

open-contracting / kingfisher-summarize

Creates SQL tables that summarize the OCDS data in collections from Kingfisher Process

https://kingfisher-summarize.readthedocs.io/en/latest/

BSD 3-Clause "New" or "Revised" License

3 stars 8 forks source link

update List the collections in the current schema #224

Closed fppenna closed 1 year ago

fppenna commented 1 year ago

I'm deleting the join between release_summary and collection tables as release_summary contains all the fields in the select distinct statement. The only field they share (source_id) contains the same information in both. (The previous query didn't work)