Hi Larry,
How about a query like
SELECT equipment from equip_tbl
where equipment not in
(select equipment from equip_tbl, WO_tbl
where equip_nr = wo_equip_nr
and wo_date between <date range>)
Bob
-----Original Message-----
From: McCown, Larry [mailto:MCCOWLA@MAIL.NORTHGRUM.COM]
Sent: Wednesday, November 03, 1999 10:12 AM
To: Multiple recipients of list SQR-USERS
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