SELECT a.AccountID18, a.Email, a.[Supply ContractID18], b.id AS ContactID FROM [SF Report - MKB Verl Reg BINNEN 100] a JOIN Contact_Salesforce b ON a.AccountId18 = b.AccountId