Thread: Crossed Reference Query
MS Access has a functionality which is a type of query called "Crossed Reference Query" (At least, that's the lame translation i got to come up with).
The syntax is something like this:
TRANSFORM Max(Consulta1.nome) AS [O valor]
SELECT Consulta1.usuario_id, Max(Consulta1.nome) AS [Total de nome]
FROM Consulta1
GROUP BY Consulta1.usuario_id
PIVOT Consulta1.textoitem;
SELECT Consulta1.usuario_id, Max(Consulta1.nome) AS [Total de nome]
FROM Consulta1
GROUP BY Consulta1.usuario_id
PIVOT Consulta1.textoitem;
The query Consulta1 is:
SELECT sig_permissoes.usuario_id, sig_menudecontrole.textoitem, sig_niveis.nome
FROM sig_niveis INNER JOIN (sig_menudecontrole INNER JOIN sig_permissoes ON sig_menudecontrole.menu_id = sig_permissoes.menu_id) ON sig_niveis.nivel_id = sig_permissoes.nivel_id
ORDER BY sig_permissoes.usuario_id, sig_menudecontrole.painel_id, sig_menudecontrole.numeroitem;
FROM sig_niveis INNER JOIN (sig_menudecontrole INNER JOIN sig_permissoes ON sig_menudecontrole.menu_id = sig_permissoes.menu_id) ON sig_niveis.nivel_id = sig_permissoes.nivel_id
ORDER BY sig_permissoes.usuario_id, sig_menudecontrole.painel_id, sig_menudecontrole.numeroitem;
Well, i want to know whether is possible to do something like this over PostgreSQL. If it's needed perl scripts or some other type of scripting, for me that's ok. the thing is that i need to have that.
Is it possible?
Thanks to all.
Eduardo Mylonas da Silva
Automat Eng. de Automação
Desenvolovimento
mailto: emylonas@automat.com.br
www.automat.com.br
Automat Eng. de Automação
Desenvolovimento
mailto: emylonas@automat.com.br
www.automat.com.br