Losing or filtering of emails because of content

[Don M]

I have a problem with outlook appearing to filter a message. Here is the body
of the message that gets filtered.

-----------start of body-------------------

I think there are quite a few missing.


SELECT * FROM ArchiveUtilityCustomerInformation auci,
MeterSocketCrossReference mscr
WHERE 1=1
AND LEFT(ORDER_NUMBER,13) = mscr.UtilityMeterSocketId
AND auci.TRANSID = 'CR'
AND mscr.MeterSocketId NOT IN (SELECT MeterSocketid FROM InventoryWorkOrder
iwo)
AND SUBSTRING(auci.SEQ_NUMBER,5,5) IN (SELECT MeterReadingRoute FROM
ArchiveRouteRequest arr)
ORDER BY ORDER_NUMBER

-----------end of body-------------------


and if I rempove ArchiveRouteRequest

-----------start of body-------------------

I think there are quite a few missing.


SELECT * FROM ArchiveUtilityCustomerInformation auci,
MeterSocketCrossReference mscr
WHERE 1=1
AND LEFT(ORDER_NUMBER,13) = mscr.UtilityMeterSocketId
AND auci.TRANSID = 'CR'
AND mscr.MeterSocketId NOT IN (SELECT MeterSocketid FROM InventoryWorkOrder
iwo)
AND SUBSTRING(auci.SEQ_NUMBER,5,5) IN (SELECT MeterReadingRoute FROM Request
arr)
ORDER BY ORDER_NUMBER

-----------end of body-------------------

There are a few other headers and trailers, but I was able to forward the
second version of the email to myself, but the first version gets lost. The
identical email was sent to me and someone else in my office on the same
network and he got it.

Any ideas?