Create View_BMS in SQL

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.

Create View_BMS
create view user_travel_details as select tickets.user_ID as user_id, 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;


Leave a Comment

fourteen − 13 =