Show products that haven't been sold

[#1]

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

[#2]

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

- Sridhar