* and check the Show
checkbox, without entering anything in the Sort and Criteria boxes. In our case, we
select `author`.`name`, because we want to enter some criteria for the author's name.
Sorts
For each selected individual column, we can specify a sort (in Ascending or
Descending order) or let this line remain intact (meaning no sort). If we choose
more than one sorted column, the sort will be done with a priority from left to right.
When we ask for a column to be sorted, we normally check the Show
checkbox, but this is not necessary because we might want to do just the
sorting operation without displaying this column.
The Multi-Table Query Generator
[ 210 ]
Showing a Column
We check the Show checkbox so that we can see the column in the results.
Sometimes, we may just want to apply a criterion on a column and not include it in
the resulting page. Here, we add the phone column, ask for a sort on it, and choose
to show both the name and phone number. We also ask for a sort on the name in
ascending order. The sort will be done first by name, and then by phone number, if
the names are identical. This is because the name is in a column criterion to the left of
the phone column, and thus has a higher priority:
Updating the Query
At any point, we can click the Update Query button to see the progress of our
generated query.
Pages:
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203