Add, remove, and modify records in the database. Advanced SQL document for full

Question

Add, remove, and modify records in the database. Advanced SQL document for full details.
Explore more advanced SQL queries. Answer the questions, copy the SQL code, create screenshots, and submit the results

. When working in a normalized environment, chances are one will have to combine tables and get a result set into a table. To accomplish this task, the clause JOIN is used. Depending on what result is needed, different forms of this clause are used. They are:

INNER JOIN

OUTER JOIN (both LEFT and RIGHT)

FULL JOIN

CROSS JOIN

What all types of JOIN have in common is that they, based on a condition, match one record from one table to one or more records in another table. The result will be records that combine the data from both tables.

INNER JOINs are the most used type of JOIN. They return only the data for which matches were found.

SELECT *

FROM Person.Person

INNER JOIN HumanResources.Employee

ON Person.Person.BusinessEntityID =

HumanResources.Employee.BusinessEntityID

Using the example above, write an SQL query that returns all the information for all contacts stored in the Person.BusinessEntity table and only the jobTitle from the HumanResources.Employee table. Note that multiple rows may be returned.

Submit the SQL statement used to accomplish this task.

How many rows were affected?

Provide a screenshot of the result set.

Explanation / Answer

SELECT a.*,b.jobTitle

FROM Person.Person a

INNER JOIN HumanResources.Employee b

ON a.BusinessEntityID = b.BusinessEntityID

I don't have database so can't provide screenshot

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.