Re: SQL HELP
| From: | John Nichel | Date: | Mon, 27 Sep 2004 14:32:53 +0000 |
| Subject: | Re: SQL HELP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-197959@lists.php.net to get a copy of this message | ||
Andre wrote:
Hello I need some help on this SQL. SELECT t1.factura_id FROM factura t1, factura_conteudo t2, recibo_conteudo t4 WHERE t1.cliente_id = 1 AND t1.factura_id = t2.factura_id AND ( t4.documento_id <> t1.factura_id AND t4.valor_liquidado = "total" ) GROUP BY t1.factura_numero LIMIT 0, 30; This SQL do this result : factura_id 1 2 49 50 51 52 53 54 55 56 And the result I need is this factura_id 2 50 51 52 53 54 55 56 How can I do the SQLhttp://dev.mysql.com/doc/mysql/en/index.html http://lists.mysql.com/ -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@kegworks.com