Forum PHP.pl > Temporary columns - problem z warunkiem

Pomoc - Szukaj - Użytkownicy - Kalendarz

Pełna wersja: Temporary columns - problem z warunkiem

Forum PHP.pl > Forum > Bazy danych > MySQL

ekstro

22.06.2009, 20:11:30

Cześć, mam taki problem:

[SQL] pobierz, plaintext 
SELECT t1.id, t1.op_name,
 
@invoice_sum_tax:=(SELECT sum((b1.price_base*b1.quantity)*(b3.rate+1)) FROM t24_invoices_elements AS b1 LEFT JOIN t24_taxes AS b3 ON b3.id = b1.code_taxes WHERE code_invoices = t1.id ) AS invoice_sum_tax, 
 
@payments_sum:=(SELECT sum(c1.value) FROM t24_payments_list AS c1 WHERE c1.code_invoices = t1.id) AS payments_sum,
 
(@invoice_sum_tax-@payments_sum ) AS saldo
 
FROM (t24_invoices AS t1) LEFT JOIN t24_customers AS t2 ON t2.id=t1.code_customers
[SQL] pobierz, plaintext

i teraz nie działa ani WHERE saldo > 0 ani HAVING > 0

Będę wdzięczny za pomoc w tej kwestii.

dymsza

23.06.2009, 11:56:19

[SQL] pobierz, plaintext 
SELECT * FROM (SELECT t1.id, t1.op_name,
 
@invoice_sum_tax:=(SELECT sum((b1.price_base*b1.quantity)*(b3.rate+1)) FROM t24_invoices_elements AS b1 LEFT JOIN t24_taxes AS b3 ON b3.id = b1.code_taxes WHERE code_invoices = t1.id ) AS invoice_sum_tax,
 
@payments_sum:=(SELECT sum(c1.value) FROM t24_payments_list AS c1 WHERE c1.code_invoices = t1.id) AS payments_sum,
 
(@invoice_sum_tax-@payments_sum ) AS saldo
 
FROM (t24_invoices AS t1) LEFT JOIN t24_customers AS t2 ON t2.id=t1.code_customers ) AS t1 WHERE t1.saldo >0
[SQL] pobierz, plaintext

ekstro

23.06.2009, 15:02:12

Dzięki!

To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.