SQL Join a View with a Table
- by gamerzfuse
CREATE VIEW qtyorderedview AS
SELECT titleditors.title_id, titleditors.ed_id, salesdetails.title_id, salesdetails.qty_shipped
FROM titleditors, salesdetails
WHERE titleditors.title_id = salesdetails.title_id
I am using the above SQL statement to create a view.
I need to show Editors First Name, Last Name, City where they shipped more than 50…