title: Is there a way to join a parameter to a table?
body: <p>Not sure if this is possible based on what I've researched online. But just want to check to be sure. </p>
  
  <p>If I have a parameter such as: </p>
  
  <pre><code>declare @Person nvarchar(4000)
  set @Person = '1234567'
  </code></pre>
  
  <p>And I have a table called <code>[People]</code>, then can I join the two together?</p>
  
  <p>Something like: </p>
  
  <pre><code>SELECT * FROM [People] t1 JOIN @Person t2 ON (t1.ID = t2.ID)
  </code></pre>
  
  <p>Is such a thing possible and if so can someone please provide the syntax or an exmaple?</p>