Query bug
| From: | Daniel Ferreira Castro | Date: | Wed, 27 Mar 2002 21:00:04 +0000 |
| Subject: | Query bug | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-90421@lists.php.net to get a copy of this message | ||
I have a problem.
I have those tables on my database:
mysql> use projeto;
Database changed
mysql> show tables;
+-------------------+
| Tables_in_projeto |
+-------------------+
| ALGORITMO |
| ATAS |
| MANUAIS |
| PROJETO |
| REFERENCIAS |
| RELATORIOS |
+-------------------+
mysql> describe ALGORITMO;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| id_proj | int(11) | YES | | NULL | |
| nome | varchar(30) | YES | | NULL | |
| arquivo | varchar(100) | YES | | NULL | |
| des | tinyint(4) | YES | | NULL | |
| eng | tinyint(4) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> describe ATAS;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| id_proj | int(11) | YES | | NULL | |
| nome | varchar(30) | YES | | NULL | |
| arquivo | varchar(120) | YES | | NULL | |
| des | tinyint(4) | YES | | NULL | |
| eng | tinyint(4) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> describe MANUAIS;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| id_proj | int(11) | YES | | NULL | |
| nome | varchar(30) | YES | | NULL | |
| arquivo | varchar(100) | YES | | NULL | |
| des | tinyint(4) | YES | | NULL | |
| eng | tinyint(4) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> describe REFERENCIAS;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| id_proj | int(11) | YES | | NULL | |
| nome | varchar(30) | YES | | NULL | |
| arquivo | varchar(100) | YES | | NULL | |
| des | tinyint(4) | YES | | NULL | |
| eng | tinyint(4) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
6 rows in set (0.02 sec)
mysql> describe RELATORIOS;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| id_proj | int(11) | YES | | NULL | |
| nome | varchar(30) | YES | | NULL | |
| arquivo | varchar(100) | YES | | NULL | |
| des | tinyint(4) | YES | | NULL | |
| eng | tinyint(4) | YES | | NULL | |
+---------+--------------+------+-----+---------+----------------+
I want to select the fields nome,id_proj,arquivo FROM ALGORITMO and ATAS. But when I use the query
below, I receive the error "ERROR 1052: Column: 'nome' in field list is
ambiguous". What is wrong on my query?
query: SELECT nome,id_proj,arquivo FROM ALGORITMO,ATAS WHERE id_proj=0 AND eng=1 OR
nome="teste" OR nome="de" OR nome="parse";
Thank you
Daniel Ferreira Castro
dfcastro@ig.com.br