Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 16:50:40 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: SELECT syntax error
From:   Michael Larkins


Now that you have been told about your missing comma, you have an opportunity to improve the efficiency also. Casting data to character to make a comparison will slow down your query, especially if it is over millions of rows.

I suggest you do the following:

     where a.account_number = b.account_number
        and  a.statement_date/100 = 200408 ;

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023