The Following Queries Produce the Same Results

question 74

True/False

The following queries produce the same results.
Select DISTINCT customer_name, customer_city
from customer, salesman
where customer.salesman_id = salesman.salesman_id
and salesman.lname = 'SMITH';
select customer_name, customer_city
from customer
where customer.salesman_id =
(select salesman_id
from salesman
where lname = 'SMITH');

---

Definitions:

Renal Columns

Extensions of the renal cortex located between the renal pyramids in the kidney, which contain blood vessels and cortical tissue.

Urethra

The tube that conducts urine from the bladder to the outside of the body in both sexes, and semen in males.

Urinary Bladder

A hollow muscular organ that stores urine from the kidneys before disposal by urination.

Urogenital Sinus

An embryonic structure that, in humans, develops into parts of the urinary and reproductive systems.