[SOLVED] Write a new query. Display only the product name, product number, and the order
Write a new query. Display only the product name, product number, and the order state for all the orders for which the OrderTbl state is Colorado. Do *not* use the Group By command. Make it print only unique (distinct) product names. Sort it ascending by product name. Write a sentence: how many records do you have, and do you have any duplicate product names? Why might this be? What is the difference between this and the query you did first? (Hint: look up SELECT DISTINCT)
