This page demonstrates creation of a view on some database tables

Problem Description


The details of the products purchased by a customer is distributed between two tables 'order_master' and 'order_details'. In order to generate a customer bill, both the tables need to be queried for the relevant information.

Operation


Create a view that contains the entire purchase order information for the customers. This view enables quick generation of the customer bill. This view also addresses the security concern by not selecting the 'payment_mode' column of the order_master table

Result


The corresponding view is created