
A join? where
>>SELECT * FROM social.profile WHERE guid in
>> (SELECT guid FROM social.connections WHERE owner_guid=me)
>> In the rest of the world, we'd call that a JOIN,
I'd call a join something that joins multiple tables. I'd call that a sub-query, but doubtless there will be DBAs along soon to give us the correct term.