George Eric R Contr AFSPC/CVYZ writes:
> Ok, I can see that now. If the record doesn't exist in the tracked table, > it can't meet the window criteria. > > The one way I see to get around this, in the absense of subselects, is to > retrieve the tracked data that meets the window criteria into a temporary > table. Right? That's unnecessary. Use an ON condition instead, i.e. ... LEFT JOIN table ON field=value WHERE ... //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php