Re: [student] Simple SQL report.

From: TurkBear <johng_at_nospam.mm.com>
Date: Fri, 02 Oct 1998 15:28:56 GMT
Message-ID: <3614f0cf.6309732@news2.mm.com>

ojw_at_iinet.net.au (Oliver White) wrote:

<snip>

>3  SELECT ENAME, HIREDATE

> 4 FROM EMP
> 5* WHERE HIREDATE BETWEEN &INITDATE AND &ENDDATE;
Change to

5 WHERE HIREDATE BETWEEN '&INITDATE' AND '&ENDDATE'; That should do it....

To reply please remove the 'nospam' part of the address Received on Fri Oct 02 1998 - 10:28:56 CDT