Visual Studio TableAdapter syntax error on SQL statement
<p>This is getting pretty annoying. This SQL statement runs fine in Access:</p>

<pre><code>SELECT payrecords.*, employees.name AS employee
FROM Payrecords 
INNER JOIN employees ON payrecords.employee_id = employees.id
WHERE payrecords.payrun_id = ?
ORDER BY employees.name;
</code></pre>

<p>But the tableadapter wizard insists there is a syntax error. Even when when I replace the "?" with an actual id it whines. This happens on a number of non-vanilla SQL statements. Sometimes when I ignore the "error" the code runs fine, but sometimes not. This happens in VS 2010 and 2015. Is there a work-around maybe?</p>