EXTRACT value from COMUNI_ISTAT where not in SERVIZIO

User avatar
sal21
PlatinumLounger
Posts: 4357
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.
Top
User avatar
HansV
Administrator
Posts: 78512
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
Top

Return to “Access/SQL and other database applications”