List:General Discussion« Previous MessageNext Message »
From:Eduardo Arino de la Rubia Date:May 24 1999 6:38pm
Subject:Re: Help me!!!!!!!!!!
View as plain text  
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.
> 

Thread
Help me!!!!!!!!!!Cristina Durana24 May
  • Re: Help me!!!!!!!!!!Eduardo Arino de la Rubia24 May
  • Re: Help me!!!!!!!!!!Chris24 May
    • Re: Help me!!!!!!!!!!Steve Lihn24 May