COMPLETE SYNTAX FOR SELECT STATEMENT

 

           

  SELECT column list, function(), function(), ...

            FROM table1

                INNER JOIN table2

                ...

                ON table1.col1 = table2.col2

                ...

            WHERE criteria for row selection

            [AND criteria for row selection]
            [OR criteria for row selection]

           

  GROUP BY column list

            HAVING criteria for function results

          
            
ORDER BY column list