Select data from one table depending on the results of another select SQL Server

1rhkuytd 于 2023-10-15 发布在 SQL Server

关注(0)|答案(2)|浏览(154)

I have two tables that I need to compare to find records that are not in one table. My SQL so far is,

SELECT ORD_NAME FROM ERP_IMPORT_COMP
EXCEPT
SELECT NAME FROM OR_ORDER

This returns the ORD_NAME's of the records I want, but I would like to select all the fields in ERP_IMPORT_COMP WHERE they don't exist in OR_ORDER, matching by ORD_NAME=NAME. Is that possible?

Thanks.

sql-server

来源：https://stackoverflow.com/questions/77221577/select-data-from-one-table-depending-on-the-results-of-another-select-sql-server

2条答案

按热度按时间

vs3odd8k1#

This looks like you need to use not exists

select *
from ERP_IMPORT_COMP c
where not exists (
  select * from OR_ORDER o
  where o.NAME = c.ORD_NAME 
);

赞(0）回复(0）举报 2023-10-15

bweufnob2#

This is a classic case for a left join

SELECT I.ORD_NAME 
FROM ERP_IMPORT_COMP I
LEFT JOIN OR_ORDER O ON O.NAME = I.ORD_NAME 
WHERE O.NAME IS NULL

赞(0）回复(0）举报 2023-10-15

我来回答

Select data from one table depending on the results of another select SQL Server

2条答案

相关问题

热门标签

最新问答