Using Not Equal in VIEW

From: mbmccoy (mbmccoy_at_ems.att.com)
Date: 11/30/04

  • Next message: WJH: "Re: Order By Clause" 
    Date: Tue, 30 Nov 2004 11:43:27 -0500

    I am trying to build a VIEW. I have a situation where I want to exclude
    certain records from this view. Using a combination of criteria. I want to
    show all orders expect when CO_Code = 'ATLN' AND Service_Code = 'PL'

    So I wrote my where statement as:

    where (Co_Code != 'ATLN' and Service_Code != 'PL')

    In the results I don't see any 'PL' orders. I want PL orders. I just
    don't want PL orders when the Co_Code is 'ATLN'.

    Is there another way to exclude records with out using the !=. Because I
    think my problem is when I say !='PL' It sees that as seperate criteria and
    not as the combination of the two criteria.

  • Next message: WJH: "Re: Order By Clause"

    Relevant Pages

    • Re: what is life
      ... > If you think that you can articulate a good argument for the requisite ... Benard cells do not have this characteristic. ... > exclude them, I continue to accept them as autopoietic. ... It almost sounds as if you are saying that criteria 4-6 ...
      (sci.bio.evolution)
    • Re: Describe a real geologist (was Re: Shrinking Earth)
      ... snip ... to include, and equally important, those to exclude. ... Sometimes individuals qualify based on educational criteria alone, ... Hammond springs to mind as an example. ...
      (sci.geo.geology)
    • Re: Criteria & <>
      ... I'm trying to create a year-end check out report for my school. ... I'm having a problem creating the query for this new report. ... exclude certain records. ... I dropped to the "or" criteria line and added another title ID that I ...
      (microsoft.public.access.queries)
    • Re: Exclude records that meet criteria
      ... "david" wrote: ... It is important to mention that if the field used in the subquery has Null ... use a subquery on the second table in the criteria ... I need to exclude rather than include records from a table that meet ...
      (microsoft.public.access.modulesdaovba)
    • Re: Exclude records that meet criteria
      ... It is important to mention that if the field used in the subquery has Null ... the main query will never return anything. ... use a subquery on the second table in the criteria ... I need to exclude rather than include records from a table that meet ...
      (microsoft.public.access.modulesdaovba)