EXTRACT value from COMUNI_ISTAT where not in SERVIZIO

User avatar
sal21
PlatinumLounger
Posts: 4353
Joined: 26 Apr 2010, 17:36

EXTRACT value from COMUNI_ISTAT where not in SERVIZIO

Post by sal21 »

I need to extract all value from COMUNI_ISTAT where not in SERVIZIO

the two Fields are named ISTATEXT
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78421
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: EXTRACT value from COMUNI_ISTAT where not in SERVIZIO

Post by HansV »

SELECT * FROM COMUNI_ISTAT WHERE ISTATEXT Not In (SELECT ISTATEXT FROM SERVIZIO)
Best wishes,
Hans