Help me with one query
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
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.