Help with Transpose Query

[rrdbala]

Hi,

I just put in a sample tables here. I also put in a sample output.

Could someone help how to write a query to get a output like that.

Table -1 - product

productid name type

1 YYYYY Laptop
2 N900 Phone
3 IPAD Tablet



Table 2 - productdetails


productid attribute value

1 RAM 5GB
1 Processor i7
1 video 1080p
2 processor omap
2 RAM 32GB
2 video 320p
3 RAM 1GB
3 Processor coreduo
3 video 720p


i need an output like this
****************************

productid productname type RAM PROCESSOR
1 ASUS LAptop 4GB i7

[PAVB]

Output data is not even part of described tables.

Is this homework? - Teacher is talking about joins, isn't it?

What do you have so far?

[pallmall]

SELECT P1.PRODUCTID,
p1.name,
p1.TYPE,
ram.ATTRIBUTE ram,
ram.VALUE ramvalue,
proc.attribute proc,
proc.VALUE procvalue,
vid.attribute video,
vid.value videovalue
FROM product P1,
(SELECT VALUE, attribute, productid
FROM productdetails
WHERE upper(attribute) = upper('ram')) ram,
(SELECT VALUE, attribute, productid
FROM productdetails
WHERE UPPER (attribute) = UPPER ('processor')) proc,
(SELECT VALUE, attribute, productid
FROM productdetails
WHERE UPPER (attribute) = UPPER ('video')) vid
WHERE p1.productid = ram.productid
AND proc.productid = p1.productid
and vid.productid = p1.productid

[pallmall]

Hi,

I just put in a sample tables here. I also put in a sample output.

Could someone help how to write a query to get a output like that.

Table -1 - product

productid name type

1 YYYYY Laptop
2 N900 Phone
3 IPAD Tablet



Table 2 - productdetails


productid attribute value

1 RAM 5GB
1 Processor i7
1 video 1080p
2 processor omap
2 RAM 32GB
2 video 320p
3 RAM 1GB
3 Processor coreduo
3 video 720p


i need an output like this
****************************

productid productname type RAM PROCESSOR
1 ASUS LAptop 4GB i7

test