Hi I'm just getting started with mysql so please bear with me. =8-}
I do a 3 table query like: SELECT a.x, b.y, c.z FROM a, b, c WHERE a.b_fk = b.id AND a.c_fk = c.id; That works so far. In c can be rows which aren't active anymore. There is a good_from and a good_until DATETIME field which should be respected in the query above. Can I filter the old rows out before I do the SELECT ? I'd like to reduce the workload. In Access I used to have stored queries that I used as views on the tables that have such livetime limitations. As I understand there are no views available right now. Thanks ... Andreas --------------------------------------------------------------------- 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
