as much as i really dislike programming in SQL, it is immensely satisfying to have the queries work like I want them to... even if it does take me a few hours to actually get them working right.