Well, hard to tell what's best, if I don't know the database structure, number of records etc. But if your main concern is not to repeat the FROM and WHERE...