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
9110 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 is server side in asp.net?

966

Differentiate between authentication and authorization.

952

What does the orientation property do in a menu control?

980

What are the session management techniques asp net?

984

How to create events for a control?

998

How to add DateTime Control in normal DataGrid Server Control?

1074

Explain the benefits of viewstate?

1006

what is a .xap file? Explain with an example.

1005

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

1635

Explain how can you debug your .net application?

913

What are web beacons used for?

998

What is a master page and what does it do?

914

Is it possible to write code in many languages in one asp.net project?

1007

How to find last error which occurred?

1023

What is web api vs wcf?

1003