hi
i have one table which included 4 fields
field1 field2 field3 field4
a b null null
a c null null
null null a b
what is the statement which give me the value which in field1 and field1 but not in field3 and...