SELECT statement is the most used keyword in any SQL language. Using it intelligently saves a lot of time and memory usage. The basic full syntax for the SELECT statement in Teradata SQL goes like this; SELECT [ALL][TOP {integer | decimal} [PERCENT][WITH TIES]] {*[.ALL]} FROM [joined_table [RIGHT] JOIN joined_table ON search condition] [FULL] [CROSS JOIN] [...]

To run a very long SQL query put it in a file and run the file from the BTEQ command prompt as follows .run file=filename path (i.e. c:\mypath\mysubpath\myfirstBTEQ.txt; To set/change default database for the session; Database <database name>; To display all the default BTEQ settings show control; To show object (table, view etc) definition or [...]