Friday, 30 September 2022

sql remove not existing ids in table one

How to Delete Rows That do not Exist in Another Table


 select a.orderid from web.orderHeader a

 WHERE web.orderHeader.orderid NOT IN (SELECT f.orderid 

                        FROM web.orderdetail f)

Using NOT IN:

DELETE FROM orderHeader
 WHERE orderid NOT IN (SELECT f.orderid 
                        FROM orderdetail f)

Using NOT EXISTS:

DELETE FROM orderHeader
 WHERE NOT EXISTS(SELECT NULL
                    FROM orderdetail f
WHERE f.id = fileid)

No comments:

Post a Comment

Meet BootUI | Scan AI-Generated Code & Find What AI Missed !

 very usefull link to verify ai content https://www.youtube.com/watch?v=pULGt0Rme58 Click