True/False
The following queries produce the same results.
select 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');
Correct Answer:

Verified
Correct Answer:
Verified
Q11: Specifying the attribute names in the select
Q15: It is better not to have a
Q17: SQL statements can be included in another
Q17: All of the following are part of
Q17: What can be done with persistent stored
Q19: While triggers do run automatically,_ do not.
Q54: A subquery in which processing the inner
Q58: In order to find out what customers
Q59: Combining a table with itself results in
Q79: The natural join is very rarely used.