SELECT * FROM table; SELECT * FROM table1, table2; SELECT field1, field2 FROM table1, table2; SELECT ... FROM ... WHERE condition SELECT ... FROM ... WHERE condition GROUPBY field; SELECT ... FROM ... WHERE condition GROUPBY field HAVING condition2; SELECT ... FROM ...