Request SQL

[Ruslan Zasukhin]

On 7/5/04 4:59 PM, "Thierry Nauze" <huancaya at wanadoo.fr> wrote:

Hi Thierry ,

> I have a table : relations
> with fields : id, idIndividu,idRelation,idSource ...
> 
> How to select the records where idIndividu=idRelation
> 
> "SELECT id,idSource FROM relations WHERE idIndividu=idRelation"  select
> ALL records.
> 
> Where is the error ?

Just not implemented in Valentina 1.x

You should to use workaround:
    create BaseObject method field with formula "idIndividu=idRelation"


-- 
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
-------------------------------------------------------------