Download IXTK v5 User Manual (rev 2015.04.06)

Internet Examiner Toolkit v5 User Manual
Page 151 of 181
#2 and #3 to be treated collectively as one condition , we need to use parentheses to
group our conditions together. The following demonstrates our revised query statement.
SELECT * FROM [URLs] WHERE ([URLs].ActionDateLocal
BETWEEN #1/1/2009# AND #11/29/2009#) AND
(
([URLs].URL LIKE ‘%hotmail%’) OR ([URLs].HTMLBody
)
LIKE ‘%[email protected]%’)
ORDER BY
([URLs].ActionDateLocal) ASC
Copyright © 2004-2015, SiQuest Corporation. May not be reproduced without written permission of SiQuest Corporation.