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.