List:General Discussion« Previous MessageNext Message »
From:Steve Lihn Date:May 24 1999 6:58pm
Subject:Re: Help me!!!!!!!!!!
View as plain text  
You need all the table names listed in from clause.  so it should be

select t1.cols from t1, t2 where t1.nregisto = t2.ninterno

Mysql (older version ?) does not allow subquery, otherwise you can do

select t1.cols from t1where t1.nregisto in (select t2.ninterno from t2)

The later may be what you have in mind.

Steve Lihn
-------------------------------------------------
http://www.ecoin.net/ -- Your Internet Micropyament Solution
It is Free and Fun

Chris wrote:

> > 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?
>
> Cristina, don't put quotation marks in your query. It should look like
> this:
>
> select * from t1 where t1.nregistro = t2.ninterno;
>
> --Chris
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3840@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