Entries this day: Kill_Bill_v2 Query

Kill Bill v2

10:15am JST Tuesday 27 April 2004

Going to see Kill Bill with Jimmy before work today.

12:43pm

Ooops.

Just when the cowboy bouncer guy was looking out the window to see why dogs were hollering outside his trailer, the movie cut out.

That's fucked.

12:45pm

Again. "I can't even imagine... how bad that shit must sting" shhhweeeooooo. [audio out/movie off]

I'm going to call Quentin and tell on these guys.

3:51pm

Hmm. Good movie. Less blood. Good ending. Better dialogue than v1, but still doesn't touch Pulp Fiction. I like the Chinese scenes.

Query

10:15am JST Tuesday 27 April 2004

Thanks to Tim for offering help on the query and oooooooh special thanks to Maggie for thinking of a new way to structure the query! I haven't tried it yet, but here's the new structure:

select L1.* from lesson_taught L1 INNER JOIN lessons_taught L2
  ON L1.studentID = L2.studentID 
  WHERE L1.date <= '2004/04/26' and L2.date = '2004/04/26'

Hey, that reminds me that we hadn't tried select l1.* with the original query.

One challenging thing about the development of this code is that while I'm in the live environment (office), I don't have access to the code. I've emailed myself copies of the source data from the live environment, but it's not *quite* as satisfying to make it work in the non-live environment.