SELECT [TOP...] [DISTINCT...]
  <select_list>
FROM <T1> <join_type> JOIN <T2>
  ON <join_condition>
  <join_type> JOIN ...
WHERE <where_filter>
GROUP BY <group_by_list>
HAVING <having_filter>
ORDER BY <order_by_list>

FIGURE 1 General query syntax