SQL ate my brain

I now have a SQL query to find what skills a character can self-study based on what they currently have. With no newlines in it it is about four and a half screen-widths long. But, on the other hand, it does just what I want - thank you, Canashir (at this point I realise I don't know the player's name, just his nick on #maelfroth), for the query up to the point with the first two subqueries.

I asked for help on it on Monday evening, Canashir supplied most of the query, and by Tuesday morning I'd sorted out the rest. Hooray!

A breakdown of it into clearer sections:

( Read more... )