SQL: How to 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…