Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9002 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 use of web.config file?
What is asp.net caching?
what is the difference between response.write() and response.output.write()?
What does it mean your session has timed out?
What are session and cookies?
What is form submit?
Explain automatic memory management in .net.
Can more than one person use the same login?
What is the difference between ASP.NET Webforms and ASP.NET MVC?
Why will you usually create an aspnet user account in the database for an asp.net web application?
What is the concept of view state in asp.net?
How can we create Tree control in asp.net?
What is IPostBack? How to use it?
What is query string in asp.net?
Describe Segmentation With Paging?
