Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9313 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
Any one can tell how we store tiff format images in database and retrive from the database(need for tiff format only)
Is asp.net mvc front end or backend? : Asp.Net MVC
Explain parts of assembly?
How to unit test Web API?
What permissions do asp.net applications posses by default?
What is Forms Authentication in ASP.NET?
what is DLL Hell and how it is solved in .NET? please explain clearly??
Can we make activex dll also ti execute in some process as that of client ? How can we do?
What do you mean by marshalbyref?
When Cookies are expired in ASP.NET?
What are the three parts of an http response?
What is gridview in asp.net?
What are merge modules?
Where are session variables stored?
What is a master page and what does it do?
