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
- 7740 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
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 the equivalent of date() and time() in asp.net?
How can you send an email message from an asp.net web page?
What are validator? How do you disable them?
List the major built-in objects in asp.net?
Please briefly explain the usage of global.asax?
Explain diff. Between friend and protected friend?
What are the namespace classes used in asp.net mvc? : asp.net mvc
What is the use of session in web application?
What is application variable?
What are the different types of sessions in asp.net? Name them?
What is viewstate parameter?
How does session authentication work?
How many types of state management are there in asp net?
How to implement Authentication and Authorization?
What is autopost?
