output

From: Marcel <marcelmeijer_at_keyaccess.nl>
Date: 24 Jan 2004 02:07:40 -0800
Message-ID: <b7f63037.0401240207.6119b360@posting.google.com>

Hi,

I'm trying to figure out the following problem. I've got 2 tables and 3 columns I wish to combine into one table.

rel_id (table=relation & answer)
11
22
33
44
55
...

question (table=answer)
q1
q2
q3
q4
q5
....

quantity (table=answer)
100
100
200
300
400
...

The result should look something like this

rel_id  q1  q2  q3  q4  q5 ..
11     100 100 200 300 100 ...
22     100 220 100 400 500 ...
33     200 ... 200 100 100 ...
44     ... 100 100 200 300 ...
55     200 250 230 221 219 ...
..     ... ... ... ... ... ...

Any help would be appreciated!
Marcel Received on Sat Jan 24 2004 - 04:07:40 CST