title: English terminology MySQL queries
body: <p>I need help with some "terminology" about query parts. But not only query PARTS, any "query-related figures of speech" also will be very helpful, I'm strongly interested in them. And not only about <code>SELECT</code>s (as in example below), <code>INSERT</code>s, <code>UPDATE</code>s and other queries.</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT t1.f1, t1.f2, t2.f1 AS f1a, (t2.f2 * 10) AS f2a
  FROM talbe1 AS t1
  INNER JOIN table2 AS t2 ON (t1.f4 &lt;&gt; t2.f4)
  WHERE t1.f3 &gt; t2.f3
  LIMIT 100, 9999
  </code></pre>
  
  <p>I know that:</p>
  
  <p>1) <code>t1, t2</code> - "table aliases", no mistake here?</p>
  
  <p>2) <code>f1a</code> - "field alias", <code>f2a</code> - idk... "expression alias" maybe? Is there a difference between them? Any collective naming?</p>
  
  <p>3) <code>100</code> - "offset" </p>
  
  <p>I'm not sure how to call:</p>
  
  <p>1) all between <code>SELECT</code> and <code>FROM</code>: <code>t1.f1, t1.f2, t2.f1 AS f1a, (t2.f2 * 10) AS f2a</code></p>
  
  <p>2) <code>t1.f3 &gt; t2.f3</code> "where clause"? "condition"? which is better? other variants?</p>
  
  <p>3) <code>(t1.f4 &lt;&gt; t2.f4)</code> "join condition"? </p>
  
  <p>Also interested if there is more than 1 join, can I call them somehow by "order" or "depth"? And if I can do it by "depth" then how it will be with the <code>RIGHT JOIN</code>?</p>
  
  <p>Any other interesting "naming of things" with your examples will be very helpful. Like SELF-JOIN, may be some other of joins which have special call, anything interesting you can remember.</p>