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
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)