Hi,
 I'm having a really hard time trying to figure this out so any help
would be great.
I'm working on DB2 V9.5 but I think my problem is generic sql.

I have 2 independent sql queries which are very similar with just a
different value in the where clause:

SELECT weekscum as fabbed
FROM mytable
WHERE mytable.ccin_id = 1 AND mytable.plant_id = 1 AND mytable.mytype
= 8

SELECT weekscum as planned
FROM mytable
WHERE mytable.ccin_id = 1 AND mytable.plant_id = 1 AND mytable.mytype
= 15

Both queries return 1 column of data, (13 rows long)

How do I create an SQL query that will have the output of each of
these queries as a column
e.g. 2 columns one called fabbed and the other planned

I have tried the following query but I get 13*13 rows instead of just
13 rows!

SELECT t1.planned, t2.fabbed FROM
(
SELECT weekscum as planned, mytable.ccin_id, mytable.plant_id
FROM mytable
WHERE mytable.ccin_id = 1 AND mytable.plant_id = 1 AND
mytable.mytype_id = 15
) AS t1
JOIN
(
SELECT weekscum as fabbed, mytable.ccin_id, mytable.plant_id
FROM mytable
WHERE mytable.ccin_id = 1 AND mytable.plant_id = 1 AND
mytable.mytype_id = 8
) AS t2
ON t2.ccin_id = t1.ccin_id AND t2.plant_id = t1.plant_id

Thanks in advance to anyone who can help me.