This topic contains a solution. Click here to go to the answer

Author Question: Which of the following is NOT true regarding outer joins? A) The OUTER JOIN clause returns all ... (Read 58 times)

theo

  • Hero Member
  • *****
  • Posts: 698
Which of the following is NOT true regarding outer joins?
 
  A) The OUTER JOIN clause returns all rows from two or more of the tables within the FROM clause, as long as those rows meet any WHERE or HAVING search conditions.
  B) The OUTER JOIN clause is used whenever multiple tables that are accessed through a SQL SELECT statement returns all of the records from one table and only those records from the other table where the joined fields match.
  C) The LEFT JOIN clause is used when you want to return all rows in the left table, even if no matching rows exist in the right table.
  D) The FULL OUTER JOIN clause is not supported in Microsoft Access.

Question 2

The ________ function truncates the decimal and returns only the numbers to the left of the decimal.
 
  Fill in the blank(s) with correct word



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Toya9913

  • Sr. Member
  • ****
  • Posts: 341
Answer to Question 1

A

Answer to Question 2

Integer




theo

  • Member
  • Posts: 698
Reply 2 on: Aug 28, 2018
Gracias!


covalentbond

  • Member
  • Posts: 336
Reply 3 on: Yesterday
:D TYSM

 

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

For a complete list of videos, visit our video library