Error Query [
CREATE VIEW dbo.[view_results] AS
SELECT
dbo.meeting_dates.meeting_date, dbo.meeting_dates.meetingid, dbo.results.resulthdrid, dbo.results.resultid,
dbo.events.eventid, dbo.resulthdr.eventid AS detailid, dbo.events.event_code, dbo.events.event_type,
dbo.events.description, dbo.event_details.age_group, dbo.event_details.gender,
dbo.results.registration_number, dbo.registrations.first_name, dbo.registrations.last_name,
dbo.registrations.trialist, dbo.registrations.web_ok,
dbo.results.result1, dbo.results.result2, dbo.results.result3, dbo.results.result,
dbo.results.isPB, dbo.results.place, dbo.results.place_heat, dbo.results.place_club,
dbo.results.ignore_record, dbo.results.comments
FROM dbo.registrations
INNER JOIN dbo.event_details INNER JOIN dbo.results
INNER JOIN dbo.resulthdr ON dbo.results.resulthdrid = dbo.resulthdr.resulthdrid
INNER JOIN dbo.meeting_dates ON dbo.resulthdr.meetingid = dbo.meeting_dates.meetingid ON dbo.event_details.recordid = dbo.resulthdr.eventid ON dbo.registrations.registration_number = dbo.results.registration_number
INNER JOIN dbo.events ON dbo.event_details.eventid = dbo.events.eventId
]
Array
(
[0] => Array
(
[0] => 42S02
[SQLSTATE] => 42S02
[1] => 208
[code] => 208
[2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dbo.registrations'.
[message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'dbo.registrations'.
)
)