<div>
What database platform are you using? SQL Server or Oracle?
</div>


What database platform are you using? SQL Server or Oracle?

<div>
&gt;&gt; I can of course use a select but i'm not sure the results are the same. <br />
<br />
With SELECT statement, you will get those records which can be deleted with DELETE statement.
</div>


>> I can of course use a select but i'm not sure the results are the same.

With SELECT statement, you will get those records which can be deleted with DELETE statement.

<div>
<div class="content wysiwyg-content">
I have the following query <br />
<br />
DELETE o<br />
FROM Orders o LEFT OUTER JOIN &nbsp;OrderItems On o.Id = OrderItems.OrderId <br />
Where OrderItems.OrderId IS NULL and o.OrderStatus &gt;&nbsp;1 &nbsp;<br />
<br />
is there a way i can test this script but not let it actually run so i can see the results<br />
<br />
I can of course use a select but i'm not sure the results are the same. <br />
<br />
select *<br />
FROM Orders o LEFT OUTER JOIN &nbsp;OrderItems On o.Id = OrderItems.OrderId <br />
Where OrderItems.OrderId IS NULL and o.OrderStatus &gt;&nbsp;1 &nbsp;
</div>
</div>


I have the following query 

DELETE o
FROM Orders o LEFT OUTER JOIN  OrderItems On o.Id = OrderItems.OrderId 
Where OrderItems.OrderId IS NULL and o.OrderStatus > 1  

is there a way i can test this script but not let it actually run so i can see the results

I can of course use a select but i'm not sure the results are the same. 

select *
FROM Orders o LEFT OUTER JOIN  OrderItems On o.Id = OrderItems.OrderId 
Where OrderItems.OrderId IS NULL and o.OrderStatus > 1  

test sql deleting

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.