One side effect of normalization is that you often need more than one table to get meaningful results. For example, you may have a table that includes a list of parts and the ID number for the vendor of each part. To find the name or phone number of the vendor, you would have to consult a table that contains vendor information. In many situations, either a join or a nested query will provide the information you need. Sometimes only one approach works, or one approach is better than the other one.
With these thoughts in mind, address the following:
What are the advantages and disadvantages of joins and nested queries?
Identify specific situations in which each technique would be preferred over the other.
Explain your reasoning.
