title: "Distribution Option" error in "CREATE TABLE table AS" in SQL Server
body: <p>I have been facing an issue with using CREATE TABLE AS. I have made three tables in a database. I intend to join the tables based on policy number and create a new table out of the joined data.</p>
  <pre><code>CREATE TABLE [dbo].[New_Customer_Segmentation_Data] AS 
  ( 
  SELECT *
  FROM [dbo].[CustomerSegmentation_updated]
  INNER JOIN [dbo].[DimLapse]
  ON [dbo].[CustomerSegmentation_updated].[PolicyNumber] = [dbo].[DimLapse].[Policy Number] 
  INNER JOIN [dbo].[dimclaim]
  ON [dbo].[DimLapse].[Policy Number]  = [dbo].[dimclaim].[POLICYNUMBER]
  )
  </code></pre>
  <p>It returns the error &quot;'Distribution' option must be explicitly specified in &quot;CREATE TABLE AS SELECT&quot; and &quot;CREATE MATERIALIZED VIEW&quot; statements.&quot;
  Can anyone guide me on this error?</p>