Debashish Mahonta

Debashish Mahonta

  • 1.6k
  • 126
  • 2.5k

Create a View table Joining with Three tables

Sep 25 2024 3:59 AM

I have 3 tables below. I want to create a views table joining with three tables. Example:

Employee Table

EID Name
001 Mr. Devid
002 Mr. Kamal

Location Table

LID Location
1 Dhaka
2 Khulna
3 Rangpur

Tour Table

EID DepartureID ArrivalID
001 1 2
002 3 1

My Views Table

EID Name Departure Arrival
001 Mr. Devid Dhaka Khulna
002 Mr. Kamal Rangpur Dhaka

How can i create the View table?


Answers (2)