RE: [PHP] HELP on SQL
| From: | Jay Blanchard | Date: | Mon, 27 Sep 2004 14:53:05 +0000 |
| Subject: | RE: [PHP] HELP on SQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-197964@lists.php.net to get a copy of this message | ||
[snip]
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;
[/snip]
You need to ask this on a database list (http://lists.mysql.com)