[Pgsql-ayuda] Ayuda con sentencia SQL para referencias cruzadas

Carlos Leyán B. cleyan@terra.cl
Wed, 26 Jun 2002 11:49:33 -0400 (Hora est. del Pacífico SA)


--------------Boundary-00=_LALBQL80000000000000
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: Quoted-Printable

=0D
Estimados:=0D
=0D
Quisiera saber como puedo hacer tablas de referencias cruzadas en psql,
similar a las que se hacen en Access usando TRANSFORM/PIVOT.=0D
=0D
De antemano gracias.=0D
=0D
=0D
Carlos
--------------Boundary-00=_LALBQL80000000000000
Content-Type: Text/HTML;
  charset="iso-8859-1"
Content-Transfer-Encoding: Quoted-Printable

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-885=
9-1"><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dis=
o-8859-1"><html>
<head>
<meta name=3D"GENERATOR" content=3D"IncrediMail 1.0">=0D


<!--IncrdiXMLRemarkStart>
<IncrdiX-Info>
<X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID>
<X-FVER></X-FVER>
<X-CNT>;</X-CNT>
</IncrdiX-Info>
<IncrdiXMLRemarkEnd-->
=0A</head>

<BODY background=3D"" bgColor=3D#ffffff style=3D"BACKGROUND-POSITION: 0px=
 0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial" scroll=3D"yes" X-=
FVER=3D"2.0" ORGYPOS=3D"0">
<TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D0 width=3D"95%=
" border=3D0>
 =20
  <TR>
    <TD id=3DINCREDITEXTREGION=20
    style=3D"PADDING-RIGHT: 7px; PADDING-LEFT: 7px; FONT-SIZE: 10pt; FONT=
-FAMILY: Arial"=20
    width=3D"100%">
      <DIV>&nbsp;</DIV>
      <DIV>Estimados:</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>Quisiera saber como puedo hacer tablas de referencias cruzadas=
 en=20
      psql, similar a las que se hacen en Access usando TRANSFORM/PIVOT.<=
/DIV>
      <DIV>&nbsp;</DIV>
      <DIV>De antemano gracias.</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>&nbsp;</DIV>
      <DIV>Carlos</DIV>
      <DIV>&nbsp;</DIV></TD></TR>
  <TR>
    <TD id=3DINCREDIFOOTER width=3D"100%">
      <TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
       =20
        <TR>
          <TD width=3D"100%"></TD>
          <TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD>
          <TD id=3DINCREDIANIM vAlign=3Dbottom=20
  align=3Dmiddle></TD></TR></TABLE></TD></TR></TABLE>
</BODY>
</html>
--------------Boundary-00=_LALBQL80000000000000--