InVision Interview Question

Q: Describe an SQL join and how you might accomplish something similar in NoSQL