SELECT Statement Syntax

The currently supported SELECT statement syntax is:

SELECT columnname [[as] columnalias] [,columnname [[as] 
columnalias] ]
FROM ([[dbalias.]creatorid.]tablename [[as] tablealias])
[WHERE condition]

The following guidelines apply to WHERE conditions: