What does the following SQL statement return, assuming that
all tables and column names are correct?
SELECT FirstName, StreetAddress
FROM Employees
JOIN AddressBook
ON Employees.EmpID = AddressBook.EmpID
a) Nothing, the JOIN syntax is wrong.
b) All the records form the Employees table, and only the
matching ones form the StreetAddress table.
c) All the records from the StreetAddress table and only the
matching records form the Employees table.
d) Only the matching records from the two tables.
Answer Posted / ar prabhakaran
d) Only the matching records from the two tables.
JOIN will return only matching column values from both tables.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is application session?
What are the 3 types of web?
Can asp.net work on an nt server?
What are the ways to sending the data in ASP.NET page?
What are the authentication types in asp.net?
Differentiate strong typing and weak typing
To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?
Explain what the contents of cookie?
To get the values in two different controls to match which control you use it?
What is difference between session and viewstate?
To display data in a Repeater control which template you provide?
What are Master Pages in ASP.NET?
What are the modes of updation in an updatepanel?
What are the different types of proxy patterns?
What are resource file and how do we generate resource file?