Re: Where statement HELP

[*Kandiah Lingan <KLingan@SMTPGW.ARMS.OHIO-STATE.EDU>]

Try this.....

Select
A.IETMNUM
FROM INVENTORY A
WHERE  A.LOCATION = '1-9'       ! if you are trying in either location
1 or 2 or 3 or 4 or 5......9 , use A.LOCATION IN ( '1' , '2' , '3' ,
.....'9' )
      AND A.ITEMNUM  IN (  SELECT B.ITEMNUM
                              FROM  INVENTORY  B
      WHERE  B.LOCATION  =  '202' )









-----Original Message-----
From:   McCown, Larry [mailto:MCCOWLA@MAIL.NORTHGRUM.COM]
Sent:   Tuesday, May 25, 1999 11:19 AM
To:     Multiple recipients of list SQR-USERS
Subject:        Where statement HELP


Hello,
SQR3
SQLBase
MAXIMO application
I am brain dead today.
I am trying to develop a quick little report that will identify only
those items that are in two locations.
Only if an item is in location 1-9 and 202 I want to see it otherwise
I don't.
begin-select
itemnum       &itemnum
Location        &location

from inventory
where location ?????????                        I have tried    in
(1-9,202)
and I get everything in both locations
I only want to see items if
they are located in both 1-9 and 202.
end-select
Thanks for any and all help.
Larry
Larry McCown
Northrop Grumman
One Hornet Way          WE00/W9
El Segundo, CA. 90245
e-mail MccowLa@mail.northgrum.com
(310)332-8360  fax (310)331-7452
N <<...>>