I think you want to say something like:
select nregisto, dstitulo, dsassunto from t1, t2 where t1.nregistro =
t2.ninterno;
(I didn't try it but it looks 'bout right...)
--ed
-------------------------------------------------------------------------------
1 + 1 = 3, for large values of 1. | ed@stripped | arino@stripped
-------------------------------------------------------------------------------
On Mon, 24 May 1999, Cristina Durana wrote:
> Hi all??
> Could anybody help me with this problem:
> ------------------------------------------------------------
> mysql> select * from t1;
> +----------+----------+-----------+
> | nregisto | dstitulo | dsassunto |
> +----------+----------+-----------+
> | 1000 | aaa | aaa1 |
> | 2000 | bbb | bbb1 |
> | 3000 | ccc | ccc1 |
> | 4000 | ddd | bbb1 |
> +----------+----------+-----------+
> 4 rows in set (0.01 sec)
>
> mysql> select * from t2;
> +----------+--------+-----------+---------------+
> | ninterno | dsnome | dsapelido | dsdescritores |
> +----------+--------+-----------+---------------+
> | 4 | maria | sales | bbb1 |
> | 2000 | alzira | tomas | fff1 |
> +----------+--------+-----------+---------------+
> 2 rows in set (0.00 sec)
>
> mysql> select * from t1 "where t1.nregisto = t2.ninterno";
> ERROR 1064: parse error near '"where t1.nregisto = t2.ninterno"' at line 1
> ------------------------------------------------------------
> Why is there an error?
> Can't I do that query????
> Thanks to all for your answers
> SYS
> Cristina
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3836@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
