Search about Pivot.

Cordiais saudações,

Gerson Machado

-----Mensagem original-----
De: Sebastico Carlos Santos [mailto:scarlosantos@...]
Enviada em: terça-feira, 9 de novembro de 2004 17:24
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Hierarchical tree


I have the data in accordance with the structure listed below in a table

SQL> select
CON> id_sys_plataforma,
CON> id_sys_plataforma_pai,
CON> nome_plataforma
CON> from
CON> sys_plataforma
CON> order by
CON> id_sys_plataforma;

ID_SYS_PLATAFORMA ID_SYS_PLATAFORMA_PAI NOME_PLATAFORMA
================= ===================== ================================

1 1 Microsoft Windows
2 1 Microsoft Windows 9x
3 2 Microsoft Windows 95
4 2 Microsoft Windows 98
5 3 Microsoft Windows 95 SE
6 6 Linux

I need to mount the structure, in accordance with the example

- Microsoft Windows
----- Microsoft Windows 9x
--------- Microsoft Windows 95
------------- Microsoft Windows 95 SE
--------- Microsoft Windows 98
- Linux

I anticipate gratefulness for the aid



[Non-text portions of this message have been removed]








Yahoo! Groups Sponsor


ADVERTISEMENT
HYPERLINK
"http://us.ard.yahoo.com/SIG=12920sa68/M=295196.4901138.6071305.3001176/
D=groups/S=1705115386:HM/EXP=1100111412/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com"click here

HYPERLINK
"http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=124526922"

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/

* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com

* Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004



[Non-text portions of this message have been removed]