multiple left joins CR10

[anglophobe]

When I attempt to join three tables through left joins, I'm getting a syntax error of:
Query Engine Error: 'DAO Error Code: 0xc03
Source: DAO.Database
Description: Syntax error (missing operator) in query expression 'dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID

LEFT JOIN dbo_Profile
ON dbo_Profile.LoginID = dbo_Incident.Owner'.'

I am adding in SQL to the command section of the Database expert.
The SQL command I am attempting to use is this:

SELECT dbo_Incident.RecID, dbo_Incident.IncidentNumber, dbo_Incident.Status, dbo_Incident.CreatedDateTime, dbo_AuditHistory.CreatedDateTime, dbo_AuditHistory.Fieldname, dbo_AuditHistory.OldFieldValue, dbo_AuditHistory.NewFieldValue, dbo_Incident.Service, dbo_Incident.LastModDateTime, dbo_Incident.Owner, dbo_Profile.Team

FROM dbo_Incident

LEFT JOIN dbo_AuditHistory
ON dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID

LEFT JOIN dbo.Profile
ON dbo_Profile.LoginID = dbo_Incident.Owner

If you take out the second LEFT JOIN and the dbo_Profile.Team, it works fine, or if you take out the first join and it's related fields, it works fine.
I'm using Crystal Reports 10.

 

[anglophobe]

Sorry, this was supposed to be posted to Business Objects: Crystal Reports 2 Data Access. Please Ignore.