Re: Combining queries

2002-08-14 Thread Paul DuBois
At 17:37 -0700 8/14/02, Richard Baskett wrote: >Is there a way to combine these queries? > >SELECT count(SeekID) FROM Seekers >WHERE DateLastLog(NOW()-INTERVAL 7 DAY) > >SELECT count(SeekID) FROM Seekers >WHERE DateLastLog(NOW()-INTERVAL 1 MONTH) > >Or these? > >SELECT count(ResumeID) FROM Resumes

Re: Combining queries

2002-08-14 Thread Jerry van Leeuwen
On Thu, 15 Aug 2002 10:37, you wrote: > Is there a way to combine these queries? > > SELECT count(SeekID) FROM Seekers > WHERE DateLastLog(NOW()-INTERVAL 7 DAY) > > SELECT count(SeekID) FROM Seekers > WHERE DateLastLog(NOW()-INTERVAL 1 MONTH) SELECT SUM(DateLastLog > (NOW()-INTERVAL 7 DAY)) AS

Combining queries

2002-08-14 Thread Richard Baskett
Is there a way to combine these queries? SELECT count(SeekID) FROM Seekers WHERE DateLastLog(NOW()-INTERVAL 7 DAY) SELECT count(SeekID) FROM Seekers WHERE DateLastLog(NOW()-INTERVAL 1 MONTH) Or these? SELECT count(ResumeID) FROM Resumes WHERE testResume='1' SELECT count(ResumeID) FROM Resumes