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 106 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
:D TYSM


ecabral0

  • Member
  • Posts: 310
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Atropine, along with scopolamine and hyoscyamine, is found in the Datura stramonium plant, which gives hallucinogenic effects and is also known as locoweed.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

For a complete list of videos, visit our video library