I'm trying to create a new table with the results from a query. I'm working in SQL Server 2012

```
CREATE TABLE [Service Contract Data].[dbo].[filtered_data] AS 
(
    SELECT * 
    FROM [Service Contract Data].[dbo].[New Data]
    LEFT JOIN [Service Contract Data].[dbo].[OctMktSeg] ON [Service Contract Data].[dbo].[New Data].[Customer ID] = [Service Contract Data].[dbo].[OctMktSeg].[Account Number]
    LEFT JOIN [Service Contract Data].[dbo].[tblMktSeg&MPI] ON [Service Contract Data].[dbo].[New Data].[Customer ID] = [Service Contract Data].[dbo].[tblMktSeg&MPI].[Customer ID1]
    WHERE 
        (MKTSEG LIKE '%Repair%' OR MKTSEG LIKE 'Auto Glass' OR 
         MKTSEG LIKE 'IA - Individual' OR MKTSEG IS NULL)
        AND (MPI LIKE 'N' OR MPI IS NULL)
        AND [Item Category] LIKE '%Term'
        AND [Month] >= '2015-01-01 00:00:00.000')
    ;

```

It keeps telling me there's "Incorrect syntax" near the first open parentheses and I have no idea why. Thoughts?