title: Advanced SQL INSERT
body: <p>I have this query that works fine. It selects rows into the SY.UserOptions table for the ‘Jeff’ user.</p>
  
  <p>However, I created another query that I want to do the same thing, but for every user. So I added SY.Users to the query, which in effect mulplies the 2 tables together. However, it gives me an error that I do not understand.</p>
  
  <pre><code>--This works
  SELECT ‘Jeff’, t.Application, t.Task, tl.Description
  FROM SY.Tasks t
  LEFT OUTER JOIN SY.TaskLevels tl 
  ON t.Application = tl.Application And t.Task = tl.Task AND t.DftAccessLevel = tl.AccessLevel
  
  -- This does not work
  SELECT u.[User], t.Application, t.Task, tl.Description
  FROM SY.Tasks t, SY.Users u
  LEFT OUTER JOIN SY.TaskLevels tl 
  ON t.Application = tl.Application And t.Task = tl.Task AND t.DftAccessLevel = tl.AccessLevel
  </code></pre>
  
  <p>--Here is the error</p>
  
  <blockquote>
    <p>Msg 4104, Level 16, State 1, Procedure CreateUserOptions, Line 15
    The multi-part identifier "t.Application" could not be bound.
    Msg 4104, Level 16, State 1, Procedure CreateUserOptions, Line 15
    The multi-part identifier "t.Task" could not be bound.
    Msg 4104, Level 16, State 1, Procedure CreateUserOptions, Line 15
    The multi-part identifier "t.DftAccessLevel" could not be bound.</p>
  </blockquote>
  
  <p>Can I not multiply tables together like that and include a join?</p>