title: SQL Error Code 1066 Unique Alias
body: <p>Having this issue where it's giving me an error code for not unique table/alias. Code is as follows:</p>
  
  <pre><code>SELECT
    eventplanline.PlanNo,
    LineNo,
    ResNo,
    NumberFld,
    LocName,
    TimeStart,
    TimeEnd
  FROM Facility, Location, Resourcetbl,
    Eventplan u1
    INNER JOIN eventplanline u2 ON u1.PlanNO = u2.PlanNo
    ,
    Eventplanline
    INNER JOIN Resourcetbl u3 ON u2.ResNO = u3.ResNo
    ,
    eventplanline
    INNER JOIN eventrequest u4 ON u2.eventNo = u4.EventNo
  WHERE Activity = 'Operation'
        AND WorkDate BETWEEN '2013-10-01' AND '2013-12-31'
        AND FacName = 'Basketball Arena';
  </code></pre>
  
  <p>I've added the u2, u3, u4 because it was a solution in a nother similar problem. However It still doesnt fix the issue. </p>