Re: Where statement HELP

[Diwakar Bhatt <diwakar.v.bhatt@AC.COM>]

The fastest query to do this is:
begin-select

a.itemnum         &itemnum
a.Location        &location
from inventory a, inventory b
where a.itemnum = b.itemnum
and a.location = '1-9'
and b.location = '202'

end-select


"McCown, Larry" <MCCOWLA@MAIL.NORTHGRUM.COM> (Mailed by: "McCown, Larry"
<MCCOWLA@MAIL.NORTHGRUM.COM>)
05/25/99 04:19 PM GMT
Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Diwakar V. Bhatt)
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 <<...>>