I need to write  query   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.
I keep getting error syntax  can .

0
LVL 55

Expert Comment

by:Dale Fye
@Beete,

sometimes it may not be clear in the user interface, but you selected to make a post rather than ask a question. Posts are usually used as informative pieces of information you wish to share with others in the community.  But what you are looking for is "Ask a question", so I suggest you copy the text of your post and submit it as a question.  You might also want to consider adding the type of database you are working with in the topics section, because the syntax can vary widely from one database to another.
4

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month