Re: FW: [Phpgroupware-users] ``flat'' addressbook table...

[Marco Gaiarin]

Mandi! Marco Gaiarin
  In chel di` si favelave...

> Oh, good idea, i'm using postgres so views are supported... but is not
> viable, at least for my SQL/PG knowledge...
> I can make some correlation (join) between people and addresses, but
> when i try to join the comm infos, they are organized very different
> for a flat table, so i can extract only one information (eg, the work
> fax) for addresses.

Ok, at least for what i've to do (make the phpgw adressbook usable from
whfc HylaFax client) i've solved my problem.
I'm lucky, whfc support two tables, so i've done two view, one to
extract addresses and phone number, another to extract fax number.


I'm very happy, i attach the query in hope to be usefoul...

-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  gaio(at)sv.lnf.it             tel +39-0434-842711    fax +39-0434-842797

    ... votantoniovotantoniovotantoniovotantoniovotantoniovotantonio ...
             resistenza arcobaleno contro la politica grigia

                    http://www.peacelink.it/votantonio

whfc.sql
Description: Text document