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
- 8067 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
How does u get record no from 5 to 15 from a dataset of 100 records?
i want to implement grid view value in paypal site. so how to create this code in asp.net with C#
What’s difference between “optimistic” and “pessimistic” locking?
If you are using components in your application, how can you handle exceptions raised in a component?
How can you implement encapsulation in asp.net?
Where is the view state data stored?
Explain the use of view state?
Why session is used in asp.net?
What is an example of an application service provider?
Describe the .net base class library.
Explain what are delegates?
What are the uses of reflection?
What is event in asp.net?
What is cross page posting in asp net?
Is it right that ASP.NET Web API has replaced WCF?
