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
- 8065 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 to display Alert in ASP.NET
Explain difference betn dataset and recordset?
What is caching in asp.net?
How do you do client-side validation in .net? How to disable validator control by client side javascript?
Types of instancing properties and explain each. Tell the difference between multiuse,singleuse and globalmultiuse and which is default ?
Why session management is required?
Explain managed code an un-managed code.
Explain About WebService
What is the Intermittent crashing of application in production?
What are session state modes? List some of the important session state modes of asp.net.
Explain what does mvc represent in asp.net? : asp.net mvc
Why do you use the app_code folder in asp.net?
What is asp.net file?
What are the different authentication modes in asp.net?
Why do we need master page in asp.net?
