2 Replies Latest reply on Nov 18, 2013 7:16 AM by Eric McDonald

    Duplicate aliases shown error how to rectify it.

    muthu.krishnan

       

      SELECT TOP 10000 [OrderHeader#txt].[AccountNumber] AS [AccountNumber],

       

      [OrderHeader#txt].[BillToAddressID] AS [BillToAddressID],

       

      [OrderHeader#txt].[Comment] AS [Comment],

       

      [OrderHeader#txt].[ContactID] AS [ContactID],

       

      [OrderHeader#txt].[CreditCardApprovalCode] AS [CreditCardApprovalCode],

       

      [OrderHeader#txt].[CreditCardID] AS [CreditCardID],

       

      [OrderHeader#txt].[CurrencyRateID] AS [CurrencyRateID],

       

      [OrderHeader#txt].[CustomerID] AS [CustomerID],

       

      [OrderHeader#txt].[DueDateOriginal] AS [DueDateOriginal],

       

      [OrderHeader#txt].[DueDate] AS [DueDate],

       

      [OrderHeader#txt].[Freight] AS [Freight],

       

      [Calendar#txt].[Month] AS [Month],

       

      [OrderHeader#txt].[OnlineOrderFlag] AS [OnlineOrderFlag],

       

      [OrderHeader#txt].[OrderDate] AS [OrderDate],

       

      [OrderHeader#txt].[PurchaseOrderNumber] AS [PurchaseOrderNumber],

       

      [Calendar#txt].[Quarter] AS [Quarter],

       

      [OrderHeader#txt].[RevisionNumber] AS [RevisionNumber],

       

      [OrderHeader#txt].[SalesOrderNumber] AS [SalesOrderNumber],

       

      [OrderHeader#txt].[SalesPersonID] AS [SalesPersonID],

       

      [OrderHeader#txt].[ShipDateOriginal] AS [ShipDateOriginal],

       

      [OrderHeader#txt].[ShipDate] AS [ShipDate],

       

      [OrderHeader#txt].[ShipMethodID] AS [ShipMethodID],

       

      [OrderHeader#txt].[ShipToAddressID] AS [ShipToAddressID],

       

      [OrderHeader#txt].[Status] AS [Status],

       

      [OrderHeader#txt].[SubTotal] AS [SubTotal],

       

      [OrderHeader#txt].[TaxAmt] AS [TaxAmt],

       

      [OrderHeader#txt].[TerritoryID] AS [TerritoryID],

       

      [OrderHeader#txt].[TotalDue] AS [TotalDue],

       

      [Calendar#txt].[Week] AS [Week],

       

      [Calendar#txt].[YearMonth] AS [YearMonth],

       

      [Calendar#txt].[YearQtr] AS [YearQtr],

       

      [Calendar#txt].[Year] AS [Year],

       

      [Calendar#txt].[OrderDate] AS [OrderDate],

       

      [OrderHeader#txt].[SalesOrderID] AS [SalesOrderID]

       

      FROM [Calendar#txt]

       

      INNER JOIN [OrderHeader#txt] ON [Calendar#txt].[OrderDate] = [OrderHeader#txt].[OrderDate]