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
- 8337 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
Explain asp.net web forms.
Is asp.net still used?
Where is http session stored?
What is Dynamic Web and discuss its usage with the help of real life examples?
How many web config files can be created for an application?
Which method is used to perform all validation at the page level?
Explain the use of fragment caching.
What are the features of asp.net mvc?
How do you deploy your asp.net application?
Why we use content place holder in asp.net?
What is routing in MVC?
In which event of page cycle is the viewstate available?
Contrast OOP and SOA. What are tenets of each ?
What is round trip in asp.net?
Where sessions are stored?
