Databas och PHP, en tutorial

Lista alla personers bilar

familyname	firstName	hasLicence	registrationNr	make	model	price
Hällgren	Johan	1	ABC123	Volvo	V70	199000
Larsson	Anders	1	GHI789	Renault	Clio	95000
Klasson	Klas	0	JKL987	Volvo	S40	75000
Tén	Tom	0	QWERTY	Mercedes-Benz	B 180	185500
Hällgren	Johan	1	BKW127	BMW	320d	89000
Klasson	Klas	0	ACO112	BMW	520	185000
Henriks	Anna	1	KAS911	Volvo	V70	18000
Fé	Tand	0	BUY111	VOLVO	V60	159900

SQL

SELECT p.familyname, p.firstName, p.hasLicence, c.registrationNr, c.make, c.model, c.price
FROM person p
INNER JOIN car c 
ON c.personId = p.personId;