plz help me in sql statement

[mesho100200]

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 field4


result like this


field field2

a c


plz help me in this statement

[ck9663]

Sounds like an assignment...

Here are some sample SELECT statements.

-- CK