<div>
Can you paste the full query?
</div>


<div>
<div class="content wysiwyg-content">
how do i modify the following query<br />

<pre><code id="code-8238135">I have the following query bu ti need to get the dat efrom another table,

AND hl.HISTORY_DATE &lt; DATEADD(d,DATEDIFF(d,0, GETDATE()),0)

I wan to do something like
AND hl.HISTORY_DATE &lt; DATEADD(d,DATEDIFF(d,0, SELECT [Extraction_Date] FROM [ELTO_Extraction_Date]),0)</code></pre>
</div>
</div>


sql dates

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.