Hi all ,
I have issue with sql query.. in my query , i have 4 tables
R_Table1, S_Table2, T_Table3, Q_Table4
in "R_Table1" i have two columns are 'RT1_Id int , RT1_Name nvarchar(10)
in "S_Table2" i have 3 columns are 'ST2_Id int, FK_RT1_Id int, ST2_Name nvarchar(10)
in "T_Table3" i have 4 columns are 'TT3_Id int, FK_ST2_Id int, FK_RT1_Id int , TT3_Name nvarchar(10)
in "Q_Table4" i have 5 columbs are 'QT4_Id int, FK_TT3_Id int, FK_ST2_Id int, FK_RT1_Id int, QT_Gnrt_No nvarchar(40)
by using R_Table1, S_Table2, T_Table3 tables i am inserted records into Q_Table4
in "R_Table1" i have rows are ,
|
RT1_Id
|
RT1_Name
|
|
1
|
Naga
|
|
2
|
Raju
|
In " S_Table2" i have rows are,
|
ST2_Id
|
FK_RT1_Id
|
ST2_Name
|
|
1
|
1
|
Apple
|
|
2
|
2
|
Binjal
|
in "T_Table3" I have rows are,
TT3_Id int, FK_ST2_Id int, FK_RT1_Id int , TT3_Name nvarchar(10)
|
TT3_Id
|
FK_ST2_Id
|
FK_RT1_Id
|
TT3_Name
|
|
1
|
1
|
1
|
Fruit
|
|
2
|
2
|
2
|
Vegetable
|
in "Q_Table4" I have rows are,
QT4_Id int, FK_RT1_Id int, int, int, QT_Gnrt_No nvarchar(40)
|
QT4_Id
|
FK_TT3_Id
|
FK_ST2_Id
|
FK_RT1_Id
|
QT_Gnrt_No
|
|
1
|
1
|
1
|
1
|
ASP-1
|
|
2
|
2
|
2
|
2
|
ASP-2
|
|
1
|
1
|
1
|
1
|
ASP-3
|
|
2
|
2
|
2
|
2
|
ASP-4
|
By using above table data while retrieving data I want to get the data like below,
|
RT1_Id
|
ST2_Id
|
TT3_Id
|
RT1_Name
|
ST2_Name
|
TT3_Name
|
QT_Gnrt_No
|
|
1
|
1
|
1
|
Naga
|
Apple
|
Fruit
|
ASP-1, ASP-3
|
|
2
|
2
|
2
|
Raju
|
Binjal
|
Vegetable
|
ASP-2, ASP-4
|
if i mention any wrong information please ask me..
Did you understand my problem please help me,
Thanks in advance
