Operation Details |
Description: | This readmulti will read all of the products provided by the provider |
Sterotype: | nsmulti |
SQL |
SELECT ProductProvision.productID, Product.name, ProductProvision.productProvisionID, Product.typeCode, ProductProvision.startDate, ProductProvision.endDate INTO :productID, :name, :productProvisionID, :typeCode, :startDate, :endDate FROM Product, ProductProvision WHERE ProductProvision.providerConcernRoleID = :concernRoleID AND Product.productID = ProductProvision.productID |