Topic: SQL / Database Management

Question: Which joins produce output with columns from both tables? (choose all that apply)

Group of answer choices

1. SELECT * FROM x JOIN y ON x.key=y.key

2. SELECT * FROM x WHERE EXISTS (SELECT 1 FROM y WHERE x.key=y.key)

3. SELECT * FROM x FULL JOIN y ON x.key=y.key

4. SELECT * FROM x WHERE x.key NOT IN (SELECT y.key FROM y)

5. SELECT * FROM x, y WHERE x.key=y.key