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 #1909 is a reply to message #1908]

Tue, 09 December 2008 08:35

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

The framework isn't corrupting the sql statement it's just that the function extractTableNames returns an incorrect value:'SELECT', and therefore the records aren't filtered.

This is the correct statement, the sql statement that I want to construct is:

SELECT entidad_id, concepto, sum(importe) as importe
FROM
(SELECT entidad.entidad_id ,'Esportistes' as concepto, 1 as importe
		FROM participante 
		JOIN part_equipo_xref  ON participante.participante_id=part_equipo_xref.participante_id
		JOIN equipo  ON part_equipo_xref.equipo_id = equipo.equipo_id
		JOIN entidad  ON equipo.entidad_id= entidad.entidad_id
		JOIN temporada  ON temporada.temporada_id = equipo.temporada_id
		WHERE tippart='E'
		SELECT entidad.entidad_id ,'Equips' ,  1
		FROM participante 
		JOIN equipo  ON participante.participante_id = equipo.delegado_id
		JOIN entidad  ON equipo.entidad_id= entidad.entidad_id
		JOIN temporada  ON temporada.temporada_id = equipo.temporada_id
		UNION ALL
		SELECT entidad.entidad_id ,'Entitat',   1
		FROM entidad) as entidad_s02

[Updated on: Tue, 09 December 2008 08:36]

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:49:52 EST 2024

Total time taken to generate the page: 0.01157 seconds