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 [EMAIL PROTECTED]
