BDO interview question

I remember they ask SQL syntax to join two table