I'm trying to create a table view using SQL to join a table and a feature class together. When I try to create the view, I get an error saying there is an incorrect syntax near the keyword 'CREATE'. I've double checked my syntax with other examples and I can't figure out where I'm going wrong. I've attached the short script below:
CREATE VIEW OpDash_points AS SELECT
P.OBJECTID,
P.SITE,
P.edited_names,
P.Field12,
P.Shape,
O.Asset,
O.Project_Name,
O.Project_Status
FROM
tstgis.MPCGIS.Subs_Switches_Telecomm P,
tstgis.MBRESNAHAN.OpDash_data O
WHERE
P.SITE = O.Asset;
JOIN
keyword instead of multiple tables in theFROM
and aWHERE
to force the join, but your SQL engine (whatever is might be) might use a different syntax to create views. – Vince Nov 14 '19 at 14:13