how to split table date into seperate columns

Question

0.00/5 (No votes)

See more:

hi , i want to get result set as given below

SQL

Level_Inspection  Root_Visual  Final_Dpt    Type_Joint  Root_Visual  Final_Dpt  Type_Joint
Level - 02           100          10        Butt Weld    100          10       Nozzlewe        
Level - 05           100          10        Butt Weld    100          10       Nozzle Weld
Level - 03           100          20        Butt Weld    100          20       Nozzle Weld
Level - 1B           10           10        Butt Weld    10           10       Nozzle Weld
Level - 04           200          30        Butt Weld    200          30       Nozzle Weld


select L.Level_Inspection,N.Root_Visual,N.Final_Visual,T.Type_Joint
from Mst_NDT N,Mst_TypeJoint T,Mst_LevelInspection L
 where T.TypeJoint_Id=N.TypeJoint_Id and L.Level_Id=N.Level_Id ;

-- I written the above query and getting output as below

Level_Inspection  Root_Visual  Final_Dpt  Type_Joint
Level - 02	    100	          10       Butt Weld
Level - 05	    100		  10       Butt Weld
Level - 03	    100		  20       Butt Weld
Level - 1B	    100	       	  10       Butt Weld
Level - 04	    100		  10       Butt Weld
Level - 02	    100	          20       Nozzle Weld
Level - 05	    100		  20       Nozzle Weld
Level - 03	    100		  10       Nozzle Weld
Level - 1B	    10		  20       Nozzle Weld
Level - 04	    200		  10       Nozzle Weld

Posted 23-Apr-13 0:30am

ali from hyd

Updated 23-Apr-13 0:41am

gvprabu

v4

Add a Solution

Comments

StianSandberg 23-Apr-13 6:32am

and your question is?

ali from hyd 23-Apr-13 6:34am

select L.Level_Inspection,N.Root_Visual,N.Final_Visual,T.Type_Joint
from Mst_NDT N,Mst_TypeJoint T,Mst_LevelInspection L
where T.TypeJoint_Id=N.TypeJoint_Id and L.Level_Id=N.Level_Id ;

StianSandberg 23-Apr-13 6:35am

and so? What is your question?

ali from hyd 23-Apr-13 6:44am

i want to get display the result as below
Level_Inspection Root_Visual Final_Dpt Type_Joint Root_Visual Final_Dpt Type_Joint
Level - 02 100 10 Butt Weld 100 20 Nozzle Weld
Level - 05 100 10 Butt Weld 100 20 Nozzle Weld

TrushnaK 23-Apr-13 6:35am

Where is table data? your query?

ali from hyd 23-Apr-13 6:44am

select L.Level_Inspection,N.Root_Visual,N.Final_Visual,T.Type_Joint
from Mst_NDT N,Mst_TypeJoint T,Mst_LevelInspection L
where T.TypeJoint_Id=N.TypeJoint_Id and L.Level_Id=N.Level_Id ;

gvprabu 23-Apr-13 6:44am

Hi,
The 2 columns (Final_Dpt Type_Joint) are comming from 2nd Table right. U can use Sub Query in Column Level

gvprabu 23-Apr-13 6:58am

give some sample Data for all the 3 tables....

ali from hyd 23-Apr-13 7:10am

tableName: Mst_NDT

level_id Typejoint_Id Root_visual Final_Visual
1 1 100 100
2 1 100 10
3 1 100 100
4 1 100 100
5 1 100 100

tableName:Mst_TypeJoint

TypeJoint_Id Type_Joint Type
1 Butt Weld 1
2 Nozzle Weld 1
3 Socket Weld 1
4 Seal Weld 1
5 Socket Weld 1
6 Hanger 2

tableName:Mst_LevelInspection

Level_Id Level_Inspection
1 Level - 02
2 Level - 05
3 Level - 03
4 Level - 1B
5 Level - 04

gvprabu 23-Apr-13 7:21am

Your Join Condition only Problem. Use JOIN Syntax... like
SELECT Column Names FROM Table T INNER JOIN Table2 T2 On T2.ColName=T1.ColumnName like that..

gvprabu 23-Apr-13 7:29am

See, Some of the columns are missing....(Final_Dpt ect..).
From given sample Data what are the values required in ur Output?

gvprabu 23-Apr-13 7:30am

Which one is Transaction Table.... what ever u gave (3 Tables) are master Table right. U need to join these 3 master tables or what?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Alexander andri · Answer 1 · 2013-06-20T15:48:00

Solution 1

Try this,

SQL

select L.Level_Inspection,N.Root_Visual,N.Final_Visual,T.Type_Joint
from Mst_NDT N, Mst_LevelInspection L
cross join Mst_TypeJoint T
where T.TypeJoint_Id=N.TypeJoint_Id and L.Level_Id=N.Level_Id

Posted 20-Jun-13 15:48pm

Alexander andri