Databas och PHP, en tutorial

Lista alla bilar och visa ev ägare

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

SQL

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