How about select where bde.bde_entrydate between yesterday00:00 and yesterday11:59 > Date: Fri, 22 Aug 2008 11:54:29 +1000 > From: [EMAIL PROTECTED] > To: cfaussie@googlegroups.com > Subject: [cfaussie] Getting users who haven't made an entry today > > > Hi all! > > Have a system that people are supposed to log into every day and make > an entry. I've been asked to created a scheduled task that every > evening will look for all of the users who haven't made an entry today > and send them a reminder email, but I'm having trouble getting me head > around how to get that information. > > I have the following query, called "qReminders", that gets all of the entries: > > SELECT u.emailaddress, u.firstname, u.surname, u.rec_id, > bde.bde_entrydate > FROM users u > INNER JOIN body_diaries bd ON u.rec_id = bd.bdi_usr_id > INNER JOIN body_diary_entries bde ON bd.bdi_id > = bde.bde_bdi_id > WHERE u.user_level = 1 > ORDER BY u.rec_id, bde.bde_entrydate > > So then I thought I'd do a query-of-query on this one to get the > details of all the people who haven't made an entry today, but I can't > figure out what the filtering clauses would be. Just getting the > records that aren't today's won't work. I need a way to say "where > bde_entrydate does not include today's date in one of the records > returned for this user". > > Is this even a good way to go about it? I'm concerned that doing an > initial query that gets everything could become quite stupidly large > over time. > > Cheers, > > Seona. > > >
_________________________________________________________________ It's simple! Sell your car for just $40 at CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---