NOT IN operator not working with subquery.
From: Terry (ttrapp.spam.me.not_at_org.insurors)
Date: 10/26/04
- Next message: Dub333: "Re: Advanced query on numbers stored in a text field."
- Previous message: Jude G: "How do I set up a crosstab query to act like a parameter query?"
- Next in thread: John Spencer (MVP): "Re: NOT IN operator not working with subquery."
- Reply: John Spencer (MVP): "Re: NOT IN operator not working with subquery."
- Reply: david epsom dot com dot au: "Re: NOT IN operator not working with subquery."
- Reply: Michel Walsh: "Re: NOT IN operator not working with subquery."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 16:08:03 -0500
I want to get a list of company names that we have in our database, that we
have not ever sent an invoice to. Why does the following query not work? I
have been banging my head on this for about an hour and can't figure it out.
Any help would be much appreciated.
SELECT [Companyinfo].[Name], [Companyinfo].[ID#] FROM [Companyinfo] WHERE
[Companyinfo].[ID#] NOT IN (SELECT [Link ID] FROM [Invoices]);
[Invoices].[Link ID] points to [Companyinfo].[ID#]
-- Terry
- Next message: Dub333: "Re: Advanced query on numbers stored in a text field."
- Previous message: Jude G: "How do I set up a crosstab query to act like a parameter query?"
- Next in thread: John Spencer (MVP): "Re: NOT IN operator not working with subquery."
- Reply: John Spencer (MVP): "Re: NOT IN operator not working with subquery."
- Reply: david epsom dot com dot au: "Re: NOT IN operator not working with subquery."
- Reply: Michel Walsh: "Re: NOT IN operator not working with subquery."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
