I have a bit of an understanding of how a join works in a SQL query, but it's really basic and I can't quite get my head around it enough to figure out how to do what I need.
Here's the situation. I have two tables, one named pages which has columns (amongst others) called create_id and...