Radicore Forum: How To » How to make a list2 on a non existing child table

Home » RADICORE » How To » How to make a list2 on a non existing child table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: How to make a list2 on a non existing child table [message #1919 is a reply to message #1905]

Tue, 09 December 2008 15:32

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

This are the two sql statements (I removed the

from

part to make it comprehensible):

Outer:
SELECT SQL_CALC_FOUND_ROWS entidad_id, MAX(noment) as noment, sum(importe) as importe FROM ... as entidad_s01  WHERE ( entidad_id='5' ) OR ( entidad_id='6' )  GROUP BY 1    LIMIT 1 OFFSET 0 =>Count=2

Inner:
SELECT SQL_CALC_FOUND_ROWS entidad_id, concepto, sum(importe) as importe FROM .. as entidad_s02  WHERE entidad_id='5'  GROUP BY 1,2    LIMIT 10 OFFSET 0 =>Count=1

Report message to a moderator

[Message index]

		How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 06:59
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 07:45
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 08:11
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 08:15
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 08:35
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 09:12
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 10:15
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 10:43
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 10:50
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 11:31
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 11:37
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 11:52
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 11:59
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 12:39
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Tue, 09 December 2008 15:32
		Re: How to make a list2 on a non existing child table By: AJM on Tue, 09 December 2008 19:39
		Re: How to make a list2 on a non existing child table By: bonzo_bcn on Wed, 10 December 2008 04:11
		Re: How to make a list2 on a non existing child table By: AJM on Wed, 10 December 2008 04:58

Previous Topic:	Dynamic Report Column Headings
Next Topic:	get calculated field from parent table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 29 07:43:44 EST 2024

Total time taken to generate the page: 0.01212 seconds