beete hime
asked on
query syntax to retrieve "John" in some states but to exclude certain cities
I need to write a sql query to retrieve the loan number, state and city, customer first name for loans that
are in the states of CA,TX,FL,NV,NM but exclude the following cities (Dallas, SanFrancisco,
Oakland) and only return loans where customer first name begins with John.
are in the states of CA,TX,FL,NV,NM but exclude the following cities (Dallas, SanFrancisco,
Oakland) and only return loans where customer first name begins with John.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER