title: sql foward reference syntax
body: <p>Im new to SQL so I dont know the terminology and am am making words up, but I dont know where to look for this syntax - </p>
  
  <p><code>select name = p.e_full_Name 
  from db..port p, db..port_x il 
  where p.port_id = il.port_id and p.port_id = "blah"</code></p>
  
  <p>From what I can deduce, <code>name</code> is going to be the name of the p.e_full_name column, <code>p</code> and <code>il</code> are variables defined in the from statement (<code>p</code> is <code>db..port</code> table, <code>il</code> is <code>db.port_x</code> table). Is this correct? What is this syntax called, and where can I read up on it?</p>