Message
 
To
21/11/2006 17:56:09
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
Miscellaneous
ID da thread:
01171586
ID da mensagem:
01171599
Views:
12
This message has been marked as the solution to the initial question of the thread.
Not necessary. Here's an alternative that uses derived table (not tested)
SELECT hi_flcode, SUM(hi_amt), ;
		SumWldelvf, SumHddelvf  ;
	FROM hatcinfo ;
	JOIN ( ;
			SELECT lm_flcode, SUM(lm_wldelvf) AS SumWldelvf, ;
					SUM(lm_hddelvf) AS SumHddelvf FROM lotmast ;
				WHERE SUBSTR(lm_flcode,5,4) <= lcFlockNumberEnd  ;
					AND SUBSTR(lm_flcode,5,4) >= lcFlockNumberBegin  ;
				GROUP BY lm_flcode ;	
			) lm ON lm.lm_flcode = hi_flcode ;
	WHERE SUBSTR(hi_flcode,5,4) <= lcFlockNumberEnd  ;
		AND SUBSTR(hi_flcode,5,4) >= lcFlockNumberBegin  ;
	GROUP BY hi_flcode ;
	INTO CURSOR results
>Thanks, Sergey. I guaess that means that I need to execute a subquery for each field I want.
>
>>A subquery in a field list can return only 1 value
>>
...
>>	(SELECT SUM(lm_wldelvf) FROM lotmast ;
>>	WHERE lm_flcode = hi_flcode ) AS sum1,  ;
>>	(SELECT SUM(lm_hddelvf) FROM lotmast ;
>>	WHERE lm_flcode = hi_flcode ) AS Sum2 ;
>>...
>>>
--sb--
Previous
Next
Responder
Mapa
View