View source for Select (TQL)

The <code>SELECT</code> statement for [[TQL]] provides a means of obtaining data of a [[session]]. 
The 'Select' statement is consists of the <code>SELECT</code> word followed by a [[Selection type]] and the word <code>WHERE<code>. Depending on the [[Selection Type]] one or more [[Clause (TQL)|clause]]s can be added. Clauses are separated with the <code>AND</code> word. All of these parts are separated by an underscore <code>_</code>.
An example of a TQL select statement is: <code>SELECT_LOTSIZE_WHERE_CATEGORY_IS_SOCIAL_AND_STAKEHOLDERTYPE_IS_MUNICIPALITY</code>. In this example, <code>SELECT_LOTSIZE_WHERE</code> is the statement. <code>CATEGORY_IS_SOCIAL</code> is the first clause, and <code>STAKEHOLDERTYPE_IS_MUNICIPALITY</code> is the second clause. It would return all the land area taken up with social housing, which is also owned by a municipal [[stakeholder]].