<div>
delete from employees where firstname+lastname not in <br />
(select firstname+lastname from records).<br />
But I would say this is a bad design and rather I would have Emp ID as a key in the child table and delete by the id.
</div>


delete from employees where firstname+lastname not in
(select firstname+lastname from records).
But I would say this is a bad design and rather I would have Emp ID as a key in the child table and delete by the id.

<div>
The other database doesn't have an employee ID or any value like that... So how would that look in SQL?
</div>


The other database doesn't have an employee ID or any value like that... So how would that look in SQL?

<div>
you can use the same query as i mentioned earlier
</div>


you can use the same query as i mentioned earlier

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have two tables (Employees and Records) that both contain a FirstName and LastName column. &nbsp;I want to create a Delete Query that will delete every row in the Employee's table where a data row's FirstName and LastName is not found in the Records table.
</div>
</div>


Hello,
I have two tables (Employees and Records) that both contain a FirstName and LastName column.  I want to create a Delete Query that will delete every row in the Employee's table where a data row's FirstName and LastName is not found in the Records table.

Delete Rows From Database

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.