Wants an inventory report that lists all of the inventory the store has ever carried (both animals
Question:
Wants an inventory report that lists all of the inventory the store has ever carried (both animals and merchandise). Use the UNION operator to generate the result set consisting of five columns. The first column (called ID) should be the ID of the animal or item. The second column (called Description) should be the description of the item or a concatenation of category and breed (with a space dash space in between such as 'Cat - Siamese') for animals. The third column (called LPrice) should list the listprice of the animal or item. The fourth column (called Type) should be a text tag of "Animal" for animals and "Merch" for merchandise items. Sort the final result set by listprice descending.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill