title: Error in WHERE clause near '@'. Unable to parse query text C#
body: <p>I am trying to add a parameter to my table adapter in my C# project. When I add the @ to the where clause visual studio gives me an error. Here is my SQL statement:</p>
  
  <pre><code>select PO.PO_Num,
    PO.Supplier,
    PO.DateOrdered,
    PO.DateRequired,
    PO.Terms,
    PO.Freight,
    PO.FOB,
    POItems.PO_Num as Expr1,
    POItems.Quantity,
    POItems.Description,
    POItems.Item,
    POItems.Price,
    POItems.KeyNum
  from PO,
    POItems
  where PO.PO_Num = POItems.PO_Num
    and (PO.PO_Num = @PO_Num)
  </code></pre>
  
  <p>Can someone please tell me what I am doing wrong? Thanks in advance for any help!</p>