>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
SELECT (a+b+c+d) AS e FROM ...
is that what you need?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.