Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
PostreSQL: Right Outer Join
--PostgreSQL 9.6 --'\\' is a delimiter --create two tables CREATE TABLE product( product_id INT PRIMARY KEY NOT NULL, sku CHAR(50) NOT NULL, category VARCHAR(50) NOT NULL, date TIMESTAMP, price DECIMAL (10,2) ); INSERT INTO product (product_id, sku, category,date, price)VALUES (101, 'A113M1','Mascara', '2020-04-23', 23),(102,'A212M2', 'Mascara', '2020-02-12', 23),(103,'A221NP2','Nail Polish', '2020-03-07', 15), (104, 'A332NP2','Nail Polish', '2020-05-21', 15),(105 , 'A36LIPG','Lipgloss', '2020-07-15', 19); CREATE TABLE warehouse( sku CHAR(50) PRIMARY KEY NOT NULL, upc INT NOT NULL, quantity INT NOT NULL ); INSERT INTO warehouse (sku, upc, quantity) VALUES ('A113M1', 3445-113-545, 540), ('A212M2', 3445-212-454, 230), ('A221NP2', 3445-221-43, 670), ('A332NP2', 3445-332-003, 168), ('A36LIPG', 3445-336-347, 470); SELECT product.product_id, product.sku, warehouse.upc, warehouse.quantity FROM product RIGHT OUTER JOIN warehouse ON product.sku= warehouse.sku ORDER BY warehouse.upc;
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
test
testo
Inner Join
Joins and Case
podd version
PC02-DB-UTEC
book suggestion
Weekly Average Starting on Different Days
Update as a function result
E-commerce Website SQL Analysis
stackse - search stackoverflow differently
Please log in to post a comment.