Refer to the following statement:

Select CustomerName, AccountNumber from Customers where AccountNumber in(select AccountNumber from Transactions where TransactionDate=#12/12/2005#)

Which of the following is correct?

In the sub query, * should be used instead of AccountNumber

The sub query can return only one row, so "in" should be replaced with "=in" the prime query

The sub query should be used first

None of the above

Note: This Question is unanswered, help us to find answer for this one

Check Answer