/****** Script for SelectTopNRows command from SSMS  ******/

SELECT

      B.[GOODSID]

      ,A.INDUSTRY_CNAME

      ,C.[PRODUCTTYPE_NAME]

      ,'TMALL' AS "??"

      ,D.[BRAND_NAME]

      ,E.[PROVINCE_NAME]

      ,[SHOPNAME]

      ,F.CITY_NAME

      ,[TITLE]

      ,[PRICE]

      ,[DISCOUNT]

      ,[SALE_VOLUME]

      ,[SALE_AMOUNT]

      ,[COMMEN_NUM]

      ,[POSITIVE_COMMEN]

      ,[MODERATE_COMMEN]

      ,[NEGATIVE_COMMEN]

      ,[COLLECTION_NUM]

      ,[REPUTATION]

      ,[SHOPTYPE]

      ,[SHELVES_TIME]

      ,[YEAR]

      ,[MONTH]

      ,[DETAIL_URL]

  FROM [TM_DATA].[dbo].[SALEDETIL] B left join INDUSTRY A ON A.ID=B.INDUSTRY_ID

  LEFT JOIN PRODUCTTYPE C ON B.PRODUCTTYPE_ID=C.ID

  LEFT JOIN BRAND D ON B.BRAND_ID=D.ID

  LEFT JOIN PROVINCE E ON B.PROVINCE_ID=E.ID

  LEFT JOIN CITY F ON B.CITY_ID = F.ID

  where B.[MONTH]= AND B.PROVINCE_ID= AND B.PRODUCTTYPE_ID=