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
- 7745 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
How would you get asp.net running in apache web servers? Explain it's limitations.
What is the purpose of asp.net?
Explain difference between dataset and datareader?
How would you create a permanent cookie?
Define the types of configuration files.
What is the differences between a primary key and a unique key in sql server?
What is smpte vc-1?
Differentiate between a page theme and a global theme?
Explain the advantages of caching?
Explain the main function of razor in asp.net? : asp.net mvc
What is the function used for removing an event listener?
Which is better session or viewstate?
What are the types of authentication in asp.net?
What is a 401 redirect?
What is asp according to you?
