comparing fields in SELECT statement

[Former Member]

Hey guys,

is there a way to build ONE select statement where the logic expressions compares two  fields of the database table?

e.g.:

select * from TABLE

     where FIELD_1 <> FIELD_2.

thx, M.

[bernat_loscos]

Hi,

You need use the operator 'AND' ??

Do you mean that?

select * from mara

     where matnr <> matkl

       AND loekz <> 'X'.

Regards

[Former Member]

both fields are fields in the table. I want to select those entries, which have different entries in the fields.

[bernat_loscos]

It is a weird query. I am sure that exist another way to solve your problem...

Regards,

[narendar_naidu]

hi,

you mean two fields of the same table.

if that is the case , then you cannot do it.

Reason , in where clause  u cannot compare two fields of the same table.

regards,

[RaymondGiuseppi]

You have to "qualify" the second fields,

• WHERE fieldname1 NE fieldname2 " invalid
• WHERE fieldname1 NE tablename~fieldname2 " valid

Read documentation of WHERE - sql_cond in online SELECT statement documentation.

Regards,

Raymond

[philipdavy]

This message was moderated.

[narendar_naidu]

Hi All,

Im sorry for my reply, raymond and philip are right , yes it works.

regards.