simply ans : D becoz single JOIN means "inner join" which ret

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 / vivek

4 Answers
9034 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

Please Help Members By Posting Answers For Below Questions

What is difference between asp.net and asp?

1010

What is a 404 redirect?

1010

What does mvc represent in asp.net? : asp.net mvc

1121

Why we use asp.net for website development?

866

What is a server farm in iis?

1002

Describe in brief .net framework and its components.

952

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

940

Will the asp.net validators run in server side or client side?

1108

What is the use of express session?

926

Define session in asp.net.

953

What can you do with asp.net?

907

What are the merits and demerits of viewstate?

990

How can exception be handled with out the use of try catch?

968

What is the difference between table and query?

932

Explain the difference between server.transfer and response.redirect? Why would I choose one over the other?

979