McXD8vkU

19--run the two queries one by one
2CREATE EXTERNAL TABLE IF NOT EXISTS pgp18132.orderscustomers 
3
4(OrderID DOUBLE, CustomerID DOUBLE, ProductID DOUBLE, Quantity Double, Price DOUBLE) ;
5
6
7
8insert into pgp18132.orderscustomers
9 select a.orderid, a.customerid, a.productid, a.quantity, b.price 
10
11from pgp18132.orders a left outer join pgp18132.products b on a.productid=b.productid ;