Hi,

I have a case like this,

Product Table

A
B
C
D


Package Table
A
B


I want the result to be

A and B only, it's all or nothing situation

if the Package table only have A or B then return empty result set

I tried

SELECT IdProduct FROM Product A
WHERE IdProduct MACTH FULL (SELECT IdProduct FROM Package)

(I get the same result as INNER JOIN here)

So, any suggestion ?


Regards,


Surjanto

PS : v2.02

sorry wrong group