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
- 9114 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
there is two functions function a and function b like fun a(){.... ..... } fun b() { } in function b i write the coding to add two numbers and i need to dispaly the sum result in function a with out using global variable. how we do?
What are validator? How do you disable them?
Explain in what order a destructors is called.
Differentiate between namespace and assembly.
Is razor a programming language?
Describe how ASP.NET maintains process isolation for each Web application?
They mostly asked difference between versions of technologies
What is difference between cache and session?
What does asp stand for in asp.net?
How to create events for a control?
Can we handle the error and redirect to some pages using web.config?
What is inproc mode in session?
What is a user session?
Define dll hell?
What is asp.net response object?
