<div>
is this linq?<br />
<br />
SELECT Saleline.Slcustkey, CDate(DateValue(Saleline!S<wbr />lWhen)) AS SlDate<br />
FROM Saleline<br />
WHERE Saleline.SlSaleKey &lt;&gt;&nbsp;SaleLine.SlOrigSaleKey<br />
GROUP BY Saleline.Slcustkey, CDate(DateValue(Saleline!S<wbr />lWhen));
</div>


is this linq?

SELECT Saleline.Slcustkey, CDate(DateValue(Saleline!SlWhen)) AS SlDate
FROM Saleline
WHERE Saleline.SlSaleKey <> SaleLine.SlOrigSaleKey
GROUP BY Saleline.Slcustkey, CDate(DateValue(Saleline!SlWhen));

<div>
your where should be below the from ^^
</div>


<div>
SELECT Saleline.Slcustkey, CDate(DateValue(Saleline!S<wbr />lWhen)) AS SlDate<br />
FROM Saleline A,Saleline B<br />
WHERE A.SlSaleKey &lt;&gt;&nbsp;B.SlOrigSaleKey<br />
<br />
GROUP BY A.Slcustkey, CDate(DateValue(A!SlWhen))<wbr />;
</div>


SELECT Saleline.Slcustkey, CDate(DateValue(Saleline!SlWhen)) AS SlDate
FROM Saleline A,Saleline B
WHERE A.SlSaleKey <> B.SlOrigSaleKey

GROUP BY A.Slcustkey, CDate(DateValue(A!SlWhen));

<div>
<div class="content wysiwyg-content">
Hello, &nbsp;I have a simple sql select statement. &nbsp;It worked fine before I added the WHERE clause. &nbsp;I need to only select records where the SlSaleKey and SlOrigSaleKey are not the same value.<br />

<pre><code id="code-184956">SELECT Saleline.Slcustkey, CDate(DateValue(Saleline!SlWhen)) AS SlDate
WHERE Saleline.SlSaleKey &lt;&gt; SaleLine.SlOrigSaleKey
FROM Saleline
GROUP BY Saleline.Slcustkey, CDate(DateValue(Saleline!SlWhen));
</code></pre>
</div>
</div>


Hello,  I have a simple sql select statement.  It worked fine before I added the WHERE clause.  I need to only select records where the SlSaleKey and SlOrigSaleKey are not the same value.

Need help with a simple SQL select statement

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.