2 fields the same in a record

[joeldamole]

hello
i am making a query that shows all records which have the same text value in two fields. What criteria do i need to use for this?



Thanks
joeldamole.

[Rixxe]

Something like this:

 
select a.*
from Table1 as a
where a.Field1 ='Text' and a.Field2 ='Text'

or change the where clause to:

where a.Field1 = a.Field2