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');
Correct Answer:

Verified
Correct Answer:
Verified
Q60: Discuss some of the SQL:2011 and SQL:2016
Q61: Triggers have three parts: the event, the
Q62: What would the following view contain for
Q63: When a user creates a virtual table
Q64: The joining condition of an equi-join is
Q66: The following code would include: <br>SELECT Customer_T.CustomerID,CustomerName,
Q67: A natural join is the same as
Q68: Discuss the differences between an equi-join, natural
Q69: IF-THEN-ELSE logical processing cannot be accomplished within
Q70: Constraints are a special case of triggers.