This may or may not be due to my lack of knowledge on the use of outer join. I am getting the error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'IncidentId'.
From my query:
SELECT Incident_Incidents.RelatedIncidentId,
Incident_Incidents.RelatedType,
Incident.Subject,
Incident.RecordId
From Incident_Incidents, Incident
left outer join IncidentId on Incident.IncidentId = Incident_Incidents.IncidentId
where Incident.IncidentId = 12838
Any ideas?
SELECT
Y.RelatedIncidentId,
X.RelatedType,
X.Subject,
X.RecordId
From
Incident_Incidents X
LEFT OUTER JOIN Incident Y
ON
X.IncidentId = Y.IncidentId
where X.IncidentId = 12838
|||Sorry not to clear on what you've got going on here, Tried running it with no luck|||Here is a sample of some real code; I might of have mistaken some of your field name. It looks like your trying to left outer join on a column name instead of a table name, which will not work.
SELECT
P.iPLANID
FROM
PLANS P
INNER JOIN Units M
ON M.iPlanid = P.iPlanid
|||my guess:
SELECT Incident_Incidents.RelatedIncidentId,
Incident_Incidents.RelatedType,
Incident.Subject,
Incident.RecordId
From Incident_Incidents
left outer join Incident on Incident.IncidentId = Incident_Incidents.RelatedIncidentId
where Incident.IncidentId = 12838
