Exploring column criteria
Three criteria columns are provided by default. This section discusses the options we have for editing their criteria. These include options for selecting columns, sorting individual columns, entering conditions for individual columns, and so on.
Column selector: Single column or all columns
The Column selector contains all the individual columns for the selected tables, plus a special choice ending with an asterisk (*) for each table, which means that all the columns are selected.
To display all the columns in the author table, we would choose `author`.* and check the Show checkbox, without entering anything in the Sort and the Criteria boxes. In our case, we select `author`.`name`, as we want to enter some criteria for the author's name.
Sorting columns
For each selected individual column, we can specify a sort (in Ascending or Descending order), or let this line remain intact (no sorting, which is the default behavior). If we choose more than one sorted column, the...
