d) Only the matching records from the two tables. JOIN will return only

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 / ar prabhakaran

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

Please Help Members By Posting Answers For Below Questions

How can I open ashx file in mobile?

1161

witch is the best insistute in sharpoint course.what abt future of share point course.

3467

Explain the purpose of storyboard.targetproperty.

948

hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.

1655

How to fetch a data from one table to another table in asp.net ?

1046

How do I upload a file from my ASP.NET page?

1052

What is page fragment caching?

959

How can we create pie chart in asp.net?

1073

What is asp.net file?

1206

Explain file-based dependency and key-based dependency.

986

What setting must be added in the configuration file to deny a particular user from accessing the secured resources?

1042

Name the namespace which is used by ado.net?

960

Can you change a Master Page dynamically at runtime?

967

In which event of the page viewstate is available?

878

What is the difference between file-based dependency and key-based dependency?

1071