Re: Query bug

From:	Erik Price	Date:	Wed, 27 Mar 2002 21:36:30 +0000
Subject:	Re: Query bug
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-90433@lists.php.net to get a copy of this message

On Wednesday, March 27, 2002, at 04:28 PM, Daniel Ferreira Castro wrote:

This way works, but not the way i would like to. Because it selects just the fields "nome","id_proj" and "arquivo" from the table ALGORITMO, and here my goal is to select those fileds of ALGORITMO and ATAS.

Then why not just add an additional lines? SELECT ALGORITMO.nome,

        ALGORITMO.id_proj,
        ALGORITMO.arquivo,
        ATAS.nome,
        ATAS.id_proj,
        ATAS.arquivo

FROM ALGORITMO,

        ATAS

WHERE ALGORITMO.id_proj=0

AND    ALGORITMO.eng=1
OR     ALGORITMO.nome="teste"
OR     ATAS.nome="de"
OR     ATAS.nome="parse";