I am new to the SQL world and with work I use SQL studio.
I have a question, I want to inner join 3 tables.
the table names are Integration.Encounter, Integration.Schedule and Integration.Person.
I have selected the specific columns I want and I coded it like this.
select top 5*
,s.[No Show Appointment]
The final part of the coding chunk I am having trouble with. I am not sure how to join everything together.
You will see I classified the column pulls by e, s, and p.
schedule table = s
person table = p
encounter table = e
all tables share a similar person ID.
all the help is greatly appreciated.