Joining tables with SQL

  • Event: 2016 CAR Conference
  • Speaker: Andrea Fuller of The Wall Street Journal
  • Date/Time: Friday, Mar. 11 at 11:30am
  • Location: Denver V
  • Audio file: No audio file available.

Learn how to join tables, matching information from one file to another. We'll use SQLite and the Firefox SQLite Manager.

This session will be most useful if: You are familiar with 'counting' , 'summing' or 'GROUP BY' in SQL and want to add another tool to your SQL skill set.

Speaker Bios

  • Andrea Fuller is a reporter for The Wall Street Journal in New York City who specializes in data analysis. She uses spreadsheets, databases, and computer code to find stories. Ms. Fuller joined the Journal in April 2014. She previously was a data journalist at Gannett Digital, The Center for Public Integrity, and The Chronicle of Higher Education. 

Related Tipsheets

  • Joining with SQL
    Learn how to join tables, matching information from one file to another. We'll use SQLite and the Firefox SQLite Manager.