How Operator Precedence Affects MySQL SELECT Queries
Sep 22, 2010, 17:33 (0 Talkback[s])
(Other stories by Rob Gravelle)
"When joining tables on common fields, if you're not diligent in
the use of AND-OR combinations in the criteria clause, be prepared
for unexpected results! Learn how to break filtering criteria into
individual steps and how to group AND-OR statements to most
effectively isolate the data that you wish to retrieve.
"The following code can be used to create and populate the
employees and shops tables. If you've downloaded the table data
from my recent articles, you don't need these as they are the
same:"
Complete Story
Related Stories:
