Control Statements › SELECT Statement › Format

Format

 [   ] {                  [                     ]   }
      SELECT[(P)] {conditional-test1 [AND conditional-test2]...}
            [(S)] {                  [OR conditional-test2 ]   }
            [(L)] {ALL               [                     ]   }
            [   ] {MATCHEDn                                    }
                  {MISSINGn                                    }
                  {SAME field-name                             }
                  {NEW field-name                              }