[AccessD] compare record fields

I don't know whether you received an answer for this

In sql you would 
Select field(s)
>From x
Where x.field1 <> x.field2

Patti
******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> pedro at plex.nl
> Sent: Wednesday, October 27, 2004 08:33 AM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] compare record fields
> 
> Hello Group,
> 
> i have a table in which i would compare two fields in one 
> record with each other.
> The result must be the record where one of the values don't 
> match with one another.
> 
> fieldA    fieldB  and several other fields
> 00123     00123
> 02345     02345
> 06789     06689
> 
> 
> result
> 
> fieldA   fieldB  and several other fields
> 06789    06689
> 
> 
> Is this possible.
> 
> Thanks
> 
> Pedro Janssen
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>