1. What are the differences between the JOIN ... USING and JOIN ... ON approaches for joining tables? Generally, ON keyword is preferred one. Explain why ON is best?
2. both Having and Where keywords can be used to filter (include or exclude) some data set in the results in SQL. Explain the difference between WHERE and HAVING usage with your own words. Provide some example.
3. Describe problems you might encounter when using the NATURAL JOIN keywords to
perform join operations.
4. Discuss why you may need to use Non-Equijoins specifically. Give an example.

Answer rating: 100% (QA)

JOINUSING vs JOINON JOINUSING It is used when there is a common column name between the two tables being joined The common column is specified directl... View the full answer