Error in queries PVP iquals

  • Thread starter Thread starter Javier VFM
  • Start date Start date
J

Javier VFM

Hello:

I have the following mistake on having realized a queri in two tables to see
the field pvp that are different, of 800 records there go out for me 144 that
are different but I can see that almost they all are iguaeles and not which
is the mistake if I put> then 5 coincidental fields go out for me, but if I
put> or <> you go out for me 144 records but I verify that the pvp are igules
in almost all. The fields are a text of 7 digits, I have not tried to make
them numerical and either. I use to see 2003.
Someone knows the motive. Thank you.
 
If you try to find the records in tableA which are not in tableB (by
comparison made on field "pvp"), try using the query wizard, which will
produces something like:

SELECT tableA.*
FROM tableA LEFT JOIN tableB
ON tableA.pvp = tableB.pvp
WHERE tableB.pvp IS NULL





Using an inner join and <> is NOT the way to go, since almost every record
from tableA will probably find a least one record, in tableB, for which its
pvp value will differ.





Vanderghast, Access MVP
 
Back
Top