[SQL] Related table question

[Ruslan Zasukhin]

on 1/18/04 8:20 PM, Eric Forget at forgete at cafederic.com wrote:

> 13)
>   a.RecID in (select ptr from keyword where name = 'Me')
> AND
>   a.RecID in (select ptr from keyword where name = 'YOU')
> 
>   Result:     CalcID      Label
> 
> Instead of:     CalcID      Label
>               1           2
> 

select A.calcId, A.label
from a
where 
  a.RecID in (select ptr from keyword where name = 'Me' AND name = 'YOU' )

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------