I can't find anything in the help about the difference between = and ==. I'm guessing the == is "more exacting". But I can't see why I only get 15 records returned from the first statement below and I get 100 returned from the 2nd. I've alltrimmed about everything so that should take care of any wierd extra spaces or anything. I visually checked the results when I got the 100 records and they're all district = "PE" and cost center = "934".
I just don't get it? Help?????
My first statement (that produces 15 records) is :
SELECT DISTINCT ITEMS.ITEM_ID ;
FROM ITEMS, DISTRC ;
WHERE alltrim(DISTRC.DISTRICT) == alltrim("PE") AND ;
alltrim(DISTRC.RC) == alltrim(ITEMS.RC) AND ;
alltrim(items.rc_cc) == ALLTRIM("934")
The second one (that produces 100 records) is:
SELECT DISTINCT ITEMS.ITEM_ID ;
FROM ITEMS, DISTRC ;
WHERE alltrim(DISTRC.DISTRICT) = alltrim("PE") AND ;
alltrim(DISTRC.RC) = alltrim(ITEMS.RC) AND ;
alltrim(items.rc_cc) = ALLTRIM("934")
Being as I've alltrimmed everything, I don't understand the difference? Thanks in advance for any help.
~~~~~~~~~~
Denise
~~~~~~~~~~