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
Can I have a unique key as foreign key?
What are the various ways to send content from one page to another?
What is the postback property in asp.net?
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is the difference between CLICK and MOUSE DOWN Event ?
How can you ensure a permanent cookie?
What are user controls?
What are the differences between primary foreign and unique keys?
What are the data controls available in asp.net?
Give some salient points of difference between request processor and request dispatcher.
What are the main requirements for caching?
What's the use of formatters in .net?
What is in a session cookie?
How to fetch a data from one table to another table in asp.net ?
In which event of the page viewstate is available?