Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Help MATCH
Fri, Jan 20 2006 9:34 PM
Permanent Link
"Surjanto"
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
Fri, Jan 20 2006 10:33 PM
Permanent Link
"Surjanto"
sorry wrong group