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
- 9145 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
How do you change the session time-out value?
Explain what the contents of cookie?
Explain the path instructions in xaml?
How to comment out asp.net tags?
can any one find and tell the difference between dot net and php which one is best ? which one we get more salary? which one is stable and which one is best for freshers and also better in future and carrer ? which one we wil get more salary sir ? please send ur valuable suggestions to kiranpulsar2007@gmail.com
What is a server cookie?
Is session server side or client side?
What is parse in asp.net?
What is asp.net localization?
Describe the differences between the lifecycles of Windows services and Standard EXE?
How does session work in asp net?
What is the differences between a primary key and a unique key in sql server?
Describe how ASP.NET maintains process isolation for each Web application?
What does uri mean?
Disable Mouse right click on web page in asp.net?
