Hello I am SQL newbie so please forgive my ignorance. I have a database of software inventory. One of the tables has all software applications installed in our environment. I have to create two reports one that list each application along with the total installed for each office, the second report is to provide counts for only the approved software. There are about 300 applications on our approved software list. Because there is nothing common to any of these application names I can not query for them easily. Is there a way for me to build a new table or view or something where I can build a approved software list that pulls from the software list. Please advise.