option d

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.

Question Posted / karuna

4 Answers
9314 Views
Syntax Softtech, I also Faced
E-Mail Answers

Answer Posted / karuna

option d

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What types of data validation events are commonly seen in the client-side form validation?

1034

What is validation in asp.net?

1141

What is the advantage of mvc over asp.net? : Asp.Net MVC

1023

List some of the important session state modes of asp.net.

1033

Elaborate differentiation between Cache and Application?

1022

Define dll hell?

1138

Web API uses which library for JSON serialization?

1142

Explain Features in ASP.NET

1138

What is mvc in asp.net tutorial? : Asp.Net MVC

1279

What are the types of session in asp.net?

1014

Explain how cookies work. Give an example of cookie abuse.

1174

What is viewstate? What does the “enableviewstate” property do?

990

What is true about application service provider?

959

Explain program to call the js function when the change is being made in the dropdown list made in asp.net mvc? : asp.net mvc

1047

What is server side session management?

984