We have students working on a Simmons database problem and they have had a question about using the NOT operator. They have been asked to find customers who shop at JC Penneys and not Walmart, but when we tried the NOT operator it was not working. Matt contacted Simmons and learned that the correct syntax is “AND NOT.” If you get questions about this, hopefully this will resolve the problem.
Wednesday, February 22, 2012
Simmons database syntax
e-mail from Gene:
We have students working on a Simmons database problem and they have had a question about using the NOT operator. They have been asked to find customers who shop at JC Penneys and not Walmart, but when we tried the NOT operator it was not working. Matt contacted Simmons and learned that the correct syntax is “AND NOT.” If you get questions about this, hopefully this will resolve the problem.
We have students working on a Simmons database problem and they have had a question about using the NOT operator. They have been asked to find customers who shop at JC Penneys and not Walmart, but when we tried the NOT operator it was not working. Matt contacted Simmons and learned that the correct syntax is “AND NOT.” If you get questions about this, hopefully this will resolve the problem.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment