1 Reply Latest reply: May 14, 2009 9:51 AM by Sridhar Ethiraj RSS

    Show products that haven't been sold

    stigqlick

      Hi

      I have problem to get the products that haven't been sold in a campaign.

      There is a large transaction table and a campaign table. I want to to sort out the products that are in the campaign table but not in the transaction table. The key is kampainId.

      Please help

       

        • Show products that haven't been sold

          Hi,

          I`m not sure , Whether i have understood your query or not.

          if i would have understood your query , attached application would be the solution.

          Create duplicate kampainId in both transaction table and campign table and compare bothe the id as such i have done in my sample application.

          Have a look at my application, you`ll get clear picture.

          Good luck Yes

          - Sridhar