"jose isaias cabrera" wrote...
Greetings!
I am trying to create a report with this query,
select id, ProjID, PClass, PSubClass, bdate, lang, wDir
From LSOpenJobs Where
cust = 'PIPA' AND
fromLang = 'EN-CA' AND
(lang = 'DE-DE' OR lang = 'PT-BR') AND
PSubClass LIKE '%-Trans' OR PSubClass Like '%-Valid' AND
(PClass = 'Language' OR PClass = 'Technical') AND
(bdate BETWEEN '2014-10-01' AND '2014-10-01')
GROUP BY id;
I am getting a bunch of records, where I should not get any. Where is
failing is the bdate. All records are before the bdate. Any thoughts on
why? Thanks.
Never mind. My apologies for the bandwidth waste. I needed one more set of
().
(PSubClass LIKE '%-Trans' OR PSubClass Like '%-Valid') AND
Igor probably telepathically told me the answer. He is that good. :-)
jic
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
