Create View_BMS in SQL
Create view as user_travel_details which include their id, name, source and destination and display column as user_id, user_name, source and destination respectively.
SQL Code: Create View_BMS in SQL Solution
create view user_travel_details as select tickets.user_ID as user_id,
users.name as user_name,
schedule.source as source, schedule.destination as destination
from schedule
join tickets on tickets.schedule_ID=schedule.schedule_ID
join users on tickets.user_id=users.user_id;Related:
- Review Comments Shared by Guest in SQL
- Maximum amount paid by Guest in SQL
- pointofinterest locations in each Town in SQL
- Payments made by Guest in SQL
- Fetch Resort Details in SQL
- Review Comment for all Resort in SQL
- Review Comment for star rating Resort in SQL
- Resort that charges the highest in SQL
- Cities having Summer Temperature More than Jaipur in SQL
- PointOfInterest Locations in Chennai in SQL
- Resort with Least Capacity in SQL
- Guest who paid highest charges in SQL
- Guest details and Total Charges paid in SQL
