I am seconding the SQLGuru here...

IMHO, the query that best addresses the needs addressed by the queries posted by Ewan is

SELECT t1.col1, t2.col2
FROM t1 INNER JOIN t2 ON t1.fk1...