Using SQL to Select Records from Multiple Tables

↔️ ↕️


hello we are going to continue looking

at sql now actually continuing with sql

select a particular query with an sql

looking at how you apply it to

two tables and actually this idea

extends across more than two tables but

i'm only going to show two tables in

this video with two examples so just a

quick recollection because it is

important for this

concept there are two really important

terms in database theory

you've got primary keys and you've got

foreign keys both are fields both for

columns in tables but we are a little

bit different a primary key uniquely

identifies a record

it must be unique for every row in your


often something like id but not always a

foreign key

Related queries:

how to fetch data from three tables in sql with join