49
Joins in SQL
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
$149.99
SingleTouch
Price
PName
SELECT pname,
price
FROM Product, Company
WHERE manufacturer=cname AND country=‘Japan’
AND price <= 200
FROM Product, Company
WHERE manufacturer=cname AND country=‘Japan’
AND price <= 200
