List:General Discussion« Previous MessageNext Message »
From:Cristina Durana Date:May 24 1999 6:36pm
Subject:Help me!!!!!!!!!!
View as plain text  
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

Thread
Help me!!!!!!!!!!Cristina Durana24 May