COMP1850 Lecture 3.2 Relational Databases and SQL Queries

Flashcards covering SQL queries, joins, and multi-table databases based on lecture notes.

JOIN

A type of SQL query used to combine tables, allowing work with normalized data across multiple tables.

Foreign Key

The primary key of another table that uniquely identifies a row in that table.

JOIN … ON …

The SQL command used to combine rows from two or more tables based on a related column.

INNER JOIN

SQL type that only shows rows where a matching ID is found in both tables, representing the intersection of the tables.

FULL OUTER JOIN

SQL type that displays every row of both tables, regardless of whether a match is found.

LEFT JOIN

SQL type that displays all rows from the first table and only matching rows from the second table.

RIGHT JOIN

SQL type that displays all rows from the second table and only matching rows from the first table.