I am trying to query two synchronized data extension and update the result to a data extension
select O.CloseDate,O.StageName,O.Id, P.Contact__c.Id,P.Id From Plot__c_Salesforce P Join Opportunity_Salesforce O On P.Opportunity__c.Id = O.Id
But i am getting a syntax errors
An error occurred while checking the query syntax. Errors: Cannot call methods on nvarchar.
An error occurred while checking the query syntax. Errors: Incorrect syntax near ')'.
What i am doing Wrong Could anyone suggest me.