Re: Equipment Not Worked on.

[Chad Slattery <Chad.Slattery@CSCLAC.IRLGOV.IE>]

Larry,
Try this
select distinct equipment from equipment_table
  where equipment not in
   (select   equipment from equipment_table
    where date between  $start and $end)

or

select distinct equipment from equipment_table
  where rowid not in
   (select   rowid  from equipment_table
    where date between  $start and $end)

they should be both the same





"McCown, Larry" <MCCOWLA@MAIL.NORTHGRUM.COM> on 03/11/99 03:12:27 PM

Please respond to SQR-USERS@LIST.IEX.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@LIST.IEX.NET>
cc:    (bcc: Chad Slattery)

Subject:  Equipment Not Worked on.




Hi all,
Here is one that has stumped me all week.
I have a monthly report that identifies work orders created within Maximo
for specific pieces of equipment within user input date ranges.  And this
is
working fine.
I have now been tasked to identify if any of these pieces of equipment had
no work done during the user input time frame.  I have looked at using not
between in the date range but then I get all the work orders outside the
date range.
Sqlbase, sqr version 3, application Maximo.

 <<FORM6.SQR>>

Any suggestions will be appreciated.
Thank you
                                Larry
                                Larry McCown
                                Northrop Grumman
                                One Northrop Ave.          WG20/51
                                Hawthorne, CA. 90250
                                e-mail MccowLa@mail.northgrum.com
                                (310)332-8360  fax (310)332-4913
                                N

FORM6.SQR