<div>
Thanks, is there no way to use joins?
</div>


<div>
delete from b where aa not in (select aa from a);<br />
<br />
delete from b where not exists (select 1 from a &nbsp;where a.aa=b.aa);<br />

</div>


delete from b where aa not in (select aa from a);

delete from b where not exists (select 1 from a  where a.aa=b.aa);


<div>
It could be done on SQL Server like this. Oracle wouldn't accept this query, so in that case you'll have to use irinaq's suggestion. (Don't know about other db's)<br />
<br />
DELETE A.*<br />
FROM A LEFT JOIN B ON A.pk = B.fk <br />
WHERE B.fk Is Null<br />

</div>


It could be done on SQL Server like this. Oracle wouldn't accept this query, so in that case you'll have to use irinaq's suggestion. (Don't know about other db's)

DELETE A.*
FROM A LEFT JOIN B ON A.pk = B.fk
WHERE B.fk Is Null


<div>
Sorry to say, but it seems you're caught in a loop.<br />
<br />
I clearly used a join (FROM A LEFT JOIN B ), i can't join them any more
</div>


Sorry to say, but it seems you're caught in a loop.

I clearly used a join (FROM A LEFT JOIN B ), i can't join them any more

<div>
<div class="content wysiwyg-content">
I 2 Tables:<br />
AdapterFeed and AdapterProperty<br />
AdapterFeed has a pk of AdapterFeedID. This forms the fk for AdapterProperty.<br />
<br />
I would like to delete all the records from AdapterProperty that don't have related records in AdapterFeed.<br />
<br />
?
</div>
</div>


I 2 Tables:
AdapterFeed and AdapterProperty
AdapterFeed has a pk of AdapterFeedID. This forms the fk for AdapterProperty.

I would like to delete all the records from AdapterProperty that don't have related records in AdapterFeed.

?

Help finding orphaned records...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.