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.
- 4 Answers
- 7738 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
Answer Posted / vivek
simply ans : D
becoz single JOIN means "inner join" which return common
record
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is autopostback in asp net?
Explain culture and uiculture values.
What are the advantages and disadvantages of Using Cookies?
What is difference between or and orelse?
List the major built-in objects in asp.net?
Explain the difference between asp & asp.net.
Explain the concept of event bubbling in ASP.NET?
Can we add code files of different languages in app_code folder?
Give me one example of Web API Routing?
What are the different session state management options available in asp.net?
Which protocol is used to call a web service?
What is asp net application object?
Explain the disadvantages of viewstate?
What threading model used in asp and asp.net?
What is the difference between cookie and session?
