| Author |
 Topic  |
|
|
pnpsql
Posting Yak Master
India
241 Posts |
 Posted - 12/28/2012 : 05:54:27
|
I WANT DATA IN PIVOT FROM BELOW QUEY PLEASE HELP.
SELECT PRD.PRODNAME ,SXC.PRODUCTID ,
SXC.CHARGEID ,
SXC.AUTOKNOCKOFF SXCKNOCKOFF, PRD.AUTOKNOCKOFF PRDKNOCKOFF FROM
PRD LEFT JOIN
SXC
ON PRD.PRODUCTID = SXC.PRODUCTID
challenge everything |
|
|
bandi
Flowing Fount of Yak Knowledge
India
1430 Posts |
Posted - 12/28/2012 : 06:56:14
|
SELECT PRD.PRODNAME, SXC.PRODUCTID, SXC.CHARGEID, SXC.AUTOKNOCKOFF, SXC.KNOCKOFF, PRD.AUTOKNOCKOFF, PRD.KNOCKOFF
FROM PRD
LEFT JOIN SXC
ON PRD.PRODUCTID = SXC.PRODUCTID
Can you provide sample input data and expected output?
--
Chandu |
 |
|
| |
Topic |
|
|
|
PIVOT HELP
