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
- 8066 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
Answer Posted / vivek
simply ans : D
becoz single JOIN means "inner join" which return common
record
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the layouts of ASP.NET Pages?
What are the elements of a website?
explain code with multi inhertance
How can you debug your.net application?
How do I know asp.net mvc version? : Asp.Net MVC
What are the advantages of using Master Pages?
What is bson in web api?
What is anonymous authentication?
How many types of session state management options available in asp.net?
What is & in a url?
Where is session cookies stored?
What are the various ways to send content from one page to another?
How can we identify that the page is post back in asp net?
Difference between using directive vs using statement?
What is a session government?
