SELECT

With the SELECT statement, you can specify the name of each column you want to retrieve from a table. You can name one or more columns from a table or view, or you can select all the columns. Each SELECT statement can select information from several tables. See also DISTINCT.

See the SQL reference for your database manager for table, view, and column limits in a SELECT statement.

If your SELECT statement specifies a table with binary data, QMF displays the table only if you provide a form with appropriate hex, bit, or user edit codes to display it reliably.