I was really surprised they asked me this (its really, really simple) but after confirming I understood the question proceeded to answer while adding some things to look out for (inner vs outer joins, poorly formatted join keys, etc).