PubNub interview question

I remember an SQL challenge - joining tables.