-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I've made a try with this:
SELECT count(journey) from DETALLTRAJECTES where EXISTS (SELECT NULL
from CAPTRAJECTE,DETALLTRAJECTES where pkey=journey and fecha=20030423);
and it doesn't work properly (at least it doesn't do what I need...)
In my last mail (this is for Nabil) I made a mistake in what I told you.
The date to filter the rows to remove is in CAPTRAJECTES, and the rows
to remove are in DETALLTRAJECTES. CAPTRAJECTES has a field called "pkey"
and DETALLTRAJECTES another called "journey" that are the join between
the two tables.
When I execute the select above noted it returns me about 15.000 rows.
But if I make this one:
SELECT count(journey) from CAPTRAJECTES,DETALLTRAJECTES where
pkey=journey and fecha=20030423;
it only returns me about 5.000. So the first one has any error in the
conception.
Where do I make the mistake? (thanks you all for your patience.....)
Josep Sànchez
~ [papapep]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+1LEd2vx52x0kyz4RAqk0AKDOo3ZoYTYKC5Pcfgov90+CLydxCwCfVgXM
RF+NLu0hs6iyR+QKGkjCbzk=
=wOrJ
-----END PGP SIGNATURE-----