MyArticle: Combining Commerce Server 2007 Catalog Tables in a View

This article of mine, describes how to union multiple catalog tables in a single view. This approach may be used for reporting purposes, thus developer will not require to find out which table contains the product, but will execute a select stmt for a view and will get the information required.
Combining Commerce Server Tables as a View