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
- 9301 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 ports must be open for DCOM over a firewall? What is the purpose of Port 135?
Is asp.net different from asp? If yes, explain how?
Which class is used to send an email message from an ASP.NET Web page?
Where viewstate value is stored in asp.net?
How to set the pane area to transparent of a scrollPane component.?
How to prevent client side validation from the ASP.NET validation controls?
How many types of validators are there in asp net?
Explain how can we access static variable?
Give me one example of Web API Routing?
What are validator? Name the validation controls in asp.net? How do you disable them? Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?
What are the two Layouts supported by a Web form in ASP.NET?
what is the difference between response.write() and response.output.write()?
What are the different types of sessions in asp.net?
What is different authentication mechanisms used in ASP.NET?
Explain security types in asp.net?
