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 / karuna
option d
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What do you mean by marshalbyref?
Should I delete cookies?
What is ASLM?
Difference between web user control and web custom control?
What types of data validation events are commonly seen in the client-side form validation?
What is special types forms
Demonstrate Render and PreRender?
What are session state modes in asp.net?
Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?
What is an il?
Explain the difference between debug.write and trace.write? When should each be used?
Where the viewstate is stored after the page postback?
Explain the components of web form in asp.net
What does asp in asp.net stand for?
Explain the difference between dataset and datareader.