Обсуждение: text concat in WHERE?

Should I be able to:
   SELECT *  from t1, t2
     WHERE t1.a || ' ' || t2.b = t2.c;

In other words, combine two fields from one table and a constant space
for the join with a single field in the other table?

  Les Mikesell
    les@mcs.com

On Fri, 5 Jun 1998, Leslie Mikesell wrote:

> Should I be able to:
>    SELECT *  from t1, t2
>      WHERE t1.a || ' ' || t2.b = t2.c;
>
Try this:
SELECT *  from t1, t2
   WHERE (t1.a || ' ') || t2.b = t2.c;

> In other words, combine two fields from one table and a constant space
> for the join with a single field in the other table?
>
>   Les Mikesell
>     les@mcs.com

                                                            Ciao, Jose'