MySQL Forums
Forum List  »  MySQL Query Browser

Help me with one query
Posted by: Pedro Vieira
Date: October 17, 2005 11:42AM

Hi people,
Pleas, any body can answer me about this query:

SELECT materiais_coletados.cod_coleta, associacoes.nome_assoc, associacoes.id_assoc, colaboradores.nome_colab, colaboradores.cod_colab, materiais_coletados.quantidade,
materiais_coletados.data_coleta, materiais_coletados.id_material, materiais.tipo_material,
materiais.cod_material

FROM materiais_coletados INNER JOIN associacoes INNER JOIN colaboradores INNER JOIN materiais

ON materiais_coletados.id_assoc = associacoes.id_assoc AND
materiais_coletados.id_colab_mat = colaboradores.cod_colab AND
materiais_coletados.id_material = materiais.cod_material

all name of tables and fields are correct ... like this .. table.field

does INNER JOIN and associations are correct ?

Please, help me. I need this "big" query for one PHP page...

Thankyou

Options: ReplyQuote


Subject
Written By
Posted
Help me with one query
October 17, 2005 11:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.