| From: | "sid(at)questions(dot)com" <sbhatt(at)installs(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PHP/Postgres Query |
| Date: | 2002-06-21 19:41:41 |
| Message-ID: | aevvi2$22tf$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
I have some 5 views created with me, my job is to pass these to an XML
stylesheet. The views have a common key that can be used to take a join on
all 5. But the problem is that for 4/5 views the common key has more than
one entry in the view-table.
eg
View A View B View C ..
K1 A1 K1 B1 K2 C1
K1 B2
K1 B3
K2 A1 K2 B1
In the views B,C,... the common key can have 0 or more values. I need to
print a report that has the common key K1 and rest of the values picked
from the remaining tables. I believe this should be possible just struggling
would appreciate all kinds of help.
Thanks
Sid
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-06-21 19:57:29 | Re: ISAM access in PostgreSQL? |
| Previous Message | Marc G. Fournier | 2002-06-21 18:34:45 | Re: Download version on website |