SQL$HELP72.HLB  —  SELECT  General Form, Format
  (B)0select-statement =                   
                                       
  select-expr qwq>qqqqqqqqqqqqqqqqqqqqwwqqqqqqqqqqqqqqqqqqqqwq>
               mq> for-update-clause qjmq> optimize-clause qj

  (B)0select-expr =                                                     
                                                                    
  qwqwq>  select-clause  qqqqqqqqqqqqwqwqqqqqqk                     
   x tq> ( select-expr )  qqqqqqqqqqqu x      x                     
   x mq>   TABLE table-ref qqqqqqqqqqj x      x                     
   mqqqqqq select-merge-clause <qqqqqqqj      x
     lqqqqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqj                     
     mqwqqqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqqqqqqqqqqqwq>
       mq> order-by-clause qj  mq> offset-clause qj  mq> limit-to-clause qj

  (B)0select-merge-clause =                              
                                                     
  qwq> EXCEPT qwqqqqqqqqqqqqqqwqqqwqqqqwqqqqqqqqqqqqqqqqqqqwqq>
   x           mq> DISTINCT qqj   x    tq> CORRESPONDING qqu
   tq> INTERSECT qwqqqqqqqqqqqqqwqu    mq> NATURAL qqqqqqqqj
   x              mq> DISTINCT qj x
   tq> MINUS qqqqqqqqqqqqqqqqqqqqqu
   mq> UNION qqwqqqqqqqqqqqqqwqqqqj
               tq> ALL qqqqqqu
               mq> DISTINCT qj

  (B)0select-clause =                                        
                                                         
  SELECT qwqqqqqqqqqqqqqwq> select-list qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
          tq> ALL qqqqqqu                                              x
          mq> DISTINCT qj                                              x
  lqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mq> FROM qwqq> table-ref qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk
            mqqqqqq , <qqqqqqj                                         x
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mwqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqwqwqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqwk
   m> WHERE predicate qqqqqqqqqqqqqqqj m> GROUP BY qw> <column-name> qux
                                                    t> value-expr qqqqux
                                                    mqqqqqqq ,<qqqqqqqjx
  lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
  mwqqqqqqqqqq>qqqqqqqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>
   mq> HAVING predicate qj                               

  (B)0select-list =                                                           
                                                                          
  qwqwqqqq> * qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwq> 
   x mqwqq> value-expr qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqwqj x   
   x   x                 mq> AS <name> qwqqqqqqqqqqqqqqqqqqqqqqwj x   x   
   x   x                                mq> edit-using-clause qj  x   x   
   x   x                                                          x   x   
   x   mwq> <table-name> qqqqqqwq> . * qqqqqqqqqqqqqqqqqqqqqqqqqqqj   x   
   x    tq> <view-name> qqqqqqqu                                      x   
   x    mq> <correlation-name> j                                      x   
   mqqqqqqqqqqqqqqqq , <qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj   

  (B)0table-ref =                                               
                                                            
  qqwqq> <table-name> qqwqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> 
    tqq> <view-name>  qqu  mq> correlation-name-clause qqu    
    tqq> derived-table qj                                x    
    mqq> joined-table qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj    
                                                            

  (B)0derived-table =                         
                                          
  qqqq> ( qwq> select-expr qqwq> ) qqqq>  
           mq> joined-table qj            
                                          

  (B)0joined-table =                          
                                          
  qqwqqqqqqq> qualified-join qqqqqqwqqqq> 
    tqqqqqqq> cross-join qqqqqqqqqqu      
    mq> ( qq> joined-table qq> ) qqj      
                                          

  (B)0qualified-join =                                                   
                                                                     
  qwq> table-ref qwqqqqqqqqqqqqqwqq> JOIN qq> table-ref qk           
   x              m> join-type qj                        x           
   x lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj           
   x mwq> ON predicate qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqw> 
   x  mq> USING qqqq> ( qw> <column-name> wq> ) qqqqqqj           x  
   x                     mqqqqqq , <qqqqqqj                       x  
   mq> table-ref q> NATURAL qwqqqqqqqqqqqqqwq> JOIN q> table-ref qj  
                             m> join-type qj                         
                                                                     

  (B)0cross-join =                                     
                                                   
  qqq> table-ref qq> CROSS JOIN qq> table-ref qqq> 
                                                   

  (B)0join-type =                        
                                     
  qqwq> INNER qqqqqqqqqqqqqqqqqqwqq> 
    tq> LEFT qqqwqq> OUTER qqqqqj    
    tq> RIGHT qqu                    
    mq> FULL qqqj                    
                                     

  (B)0correlation-name-clause =                                         
                                                                    
  q> AS <correlation-name> wqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
                           mq> ( qwq> <name-of-column> qwq> ) qqj   
                                  mqqqqqqqq , <qqqqqqqqqj           
                                                                    

  (B)0order-by-clause =                                  
                                                     
  qq> ORDER BY qwwq> value-expr   qwwqqqqqqqqqwqwqq> 
                xmq> <integer> qqqqjtq> ASC qqu x    
                x                   mq> DESC qj x    
                mqqqqqqqqqqqq , <qqqqqqqqqqqqqqqj    
                                                     

  (B)0offset-clause =                                  
                                                   
  qqq> OFFSET skip-expression qwq> ROW  qqwqq>     
                               mq> ROWS qqj        

  (B)0limit-to-clause =                           
                                             
  qw> LIMIT TO qwq> limit-expression qwqqqqqqqqqqqqqqqqqqqqqqqqqqqwwwqqqqqqqqqww>
   x            x                     tq> OFFSET skip-expression quxtq> ROW  qux
   x            x                     mq> SKIP skip-expression  qqjxmq> ROWS qjx
   x            mq> skip-expression , limit-expression  qqqqqqqqqqqj           x
   x                                                                           x
   m> FETCH qw> FIRST qwqqwqqqqqqqqqqqqqqqqqqqqqwqqwqqqqqqqqqqwq> ONLY qqqqqqqqj
             m> NEXT qqj  mq> limit-expression qj  tq> ROW  qqu
                                                   mq> ROWS  qj

  (B)0for-update-clause =                           
                                                
  qq> FOR UPDATE qwqqqqqqqqqqqqqqqqqqqqqqqqqwq> 
                  mqwq> OF <column-name> qwqj   
                    mqqqqqqqq , <qqqqqqqqqj     
                                                

  (B)0edit-using-clause =                  
                                       
  qq> EDIT USING qwq> edit-string qqqwq>   
                  mq> <domain-name> qj     

  (B)0optimize-clause =                                                 
                                                                    
  qqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq> 
    mq> OPTIMIZE qqwqwq> FOR qwq> FAST FIRST qqqqqqqqwqqqqqqqqqqwqwqj     
                   x x        tq> TOTAL TIME qqqqqqqqu          x x       
                   x x        mq> SEQUENTIAL ACCESS qj          x x
                   x tq> USING <outline-name> qqqqqqqqqqqqqqqqqqu x 
                   x tq> WITH qwq> DEFAULT  qqwq> SELECTIVITY  qu x
                   x x         tq> SAMPLED  qqu                 x x
                   x x         mq> AGGRESSIVE j                 x x
                   x mq> AS <query-name> qqqqqqqqqqqqqqqqqqqqqqqj x 
                   mqqqqqqqqqqqqqqqq <qqqqqqqqqqqqqqqqqqqqqqqqqqqqj 
                                                                    
Close Help