Hi,
I would like to know the SQL statement for field join.
In my table there have 4 (a, b, c, d)fields which join to become a new field( e ). Those fileds store the data is string not value.
I need to write a sql statement to check the e field is correctly joining by those four field.
As i know sql statement can't use "=" to join the field.

Select * from aaa
where e <> a+b+c+d

chang