topic Re: comparing fields in SELECT statement in Application Development and Automation Discussions

comparing fields in SELECT statement

Former Member — Wed, 22 Jan 2014 12:32:09 GMT

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 — Wed, 22 Jan 2014 12:41:03 GMT

Hi,

You need use the operator 'AND' ??

Do you mean that?

select * from mara

where matnr <> matkl

AND loekz <> 'X'.

Regards

Former Member — Wed, 22 Jan 2014 12:46:26 GMT

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

narendar_naidu — Wed, 22 Jan 2014 12:50:00 GMT

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 — Wed, 22 Jan 2014 12:52:10 GMT

You have to "qualify" the second fields,

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

Regards,

Raymond

bernat_loscos — Wed, 22 Jan 2014 12:57:27 GMT

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

Regards,

philipdavy — Wed, 22 Jan 2014 13:25:13 GMT

This message was moderated.

narendar_naidu — Wed, 22 Jan 2014 13:42:40 GMT

Hi All,

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

regards.