just a quick reminder about Sql joins folks- I've been pulling my hair out with them recently:

1. Only one inner join is available to SQL and you write it as "inner join" and it returns only matches, IE it removes lines from the resulting dataset.
Also, no left or right variations here are available.
2. left and right outer joins return either all the left or right rows and null on thing that don't math.

Just wrote a very funky program that uses GOLD parser engine to parse a JavaScript file. Looking at this, I can write my own compilar/interpreter for any language! Amazing!
do check I out if parsing files, especially source code makes you happy:


GOLD Parsing System

don't you just love the classical music at brittish tube stations. So very brittish.