[Babase] Query error?
Catherine Markham
amarkham at princeton.edu
Thu Aug 24 22:02:48 EDT 2006
Hi all,
I have a question about the query below. We were working in the new
system this afternoon and Laurence wanted to select all the rows in
repstats where a female was pregnant during 1999-2005. What I tried was:
create table play4 as
select * from repstats where state = 'P' and date > '1999-12-31' and
date < '2006-01-01' order by date;
This did give us an output which, as far as we could tell, seemed
correct. However, the system displayed a message saying there was a
query error.
Karl and Leah, do you see the mistake?
Thanks,
Catherine
More information about the Babase
mailing list