At 3:50 PM -0400 5/28/03, Keith C. Ivey wrote:
On 28 May 2003 at 14:17, Peter Fleck wrote:
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants,
dates
WHERE (grants.agency = "NIH-O" AND grants.grantid = dates.grantid)
GROUP BY grants.grantid ORDER BY dates.yearday;
This giv
On 28 May 2003 at 14:17, Peter Fleck wrote:
> SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants,
> dates
>WHERE (grants.agency = "NIH-O" AND grants.grantid = dates.grantid)
>GROUP BY grants.grantid ORDER BY dates.yearday;
>
> This gives me one listing per grant but they ar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote:
The results you wanted and the results you get were not very clear. Some examples
would have gone a long way.
>SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates
> WHER
