Introduction to Database Systems

47

Joins in SQL

•Connect two or more tables:

Hitachi

Household

$203.99

MultiTouch

Canon

Photography

$149.99

SingleTouch

GizmoWorks

Gadgets

$29.99

Powergizmo

GizmoWorks

Gadgets

$19.99

Gizmo

Manufacturer

Category

Price

PName

Product

Company

Japan

15

Hitachi

Japan

65

Canon

USA

25

GizmoWorks

Country

StockPrice

Cname

What is

the connection

between

them ?