Dumb question--between/and
Can someone tell me what is wrong with this between clause? Seems to cause a
long transaction, which aborts--
Select author from marc
where creation_date between "19930901*" and "19940831*" and
title_id in (select title_id from item where agency_id = "TNR")
end
Thanks--must be in the manual somewhere...
-----------------------------------------------------------------------------
Holly Gordon (hgordon@tsl.texas.gov) | SW--CLSI LIBS100+, Informix Online
4.10
Texas State Library | OS--UNIX system V, release 3.2.0 i386
Austin, Texas | HW--Sequent S27 (386)