Microsoft interview question

Q. Join in SQL, Axis Join