2 formatting
source | link

select tbl1.col1,tbl2.col2,tbl3.col3, tbl4.col4,tbl5.col5,tbl6.col6,tbl7.col7,tbl8.col8, tbl9.col9,tbl10.col10

from tbl1.col1 as tbc1

left outer join tbl2.col2 as tbc2 on tbl1.PK=tbl2.FK

left outer join tbl3 as tbc3 on tbl2.PK=tbl3.FK

left outer join tbl4 as tbc4 on tbl3.PK=tbl4.FK

left outer join tbl5 as tbc5 on tbl4.PK=tbl5.FK

left outer join tbl6 as tbc6 on tbl5.PK=tbl6.FK

left outer join tbl7 as tbc7 on tbl6.PK=tbl7.FK

left outer join tbl8 as tbc8 on tbl7.PK=tbl8.FK

left outer join tbl9 as tbc9 on tbl8.PK=tbl9.FK

left outer join tbl10 as tbc10 on tbl9.PK=tbl10.FK

where tbl1.col1='some particular column value'

Group By tbl1.col1

Order tbl1.col1

;

select tbl1.col1,tbl2.col2,tbl3.col3,
tbl4.col4,tbl5.col5,tbl6.col6,tbl7.col7,tbl8.col8,
tbl9.col9,tbl10.col10

from tbl1.col1 as tbc1 

left outer join tbl2.col2 as tbc2 on tbl1.PK=tbl2.FK
left outer join tbl3 as tbc3 on tbl2.PK=tbl3.FK
left outer join tbl4 as tbc4 on tbl3.PK=tbl4.FK
left outer join tbl5 as tbc5 on tbl4.PK=tbl5.FK
left outer join tbl6 as tbc6 on tbl5.PK=tbl6.FK
left outer join tbl7 as tbc7 on tbl6.PK=tbl7.FK
left outer join tbl8 as tbc8 on tbl7.PK=tbl8.FK
left outer join tbl9 as tbc9 on tbl8.PK=tbl9.FK
left outer join tbl10 as tbc10 on tbl9.PK=tbl10.FK

where tbl1.col1='some particular column value'
Group By tbl1.col1
Order tbl1.col1;

I am writing the sql query but it will depend on your table structure . How many there is PK and FK in your each table.

select tbl1.col1,tbl2.col2,tbl3.col3, tbl4.col4,tbl5.col5,tbl6.col6,tbl7.col7,tbl8.col8, tbl9.col9,tbl10.col10

from tbl1.col1 as tbc1

left outer join tbl2.col2 as tbc2 on tbl1.PK=tbl2.FK

left outer join tbl3 as tbc3 on tbl2.PK=tbl3.FK

left outer join tbl4 as tbc4 on tbl3.PK=tbl4.FK

left outer join tbl5 as tbc5 on tbl4.PK=tbl5.FK

left outer join tbl6 as tbc6 on tbl5.PK=tbl6.FK

left outer join tbl7 as tbc7 on tbl6.PK=tbl7.FK

left outer join tbl8 as tbc8 on tbl7.PK=tbl8.FK

left outer join tbl9 as tbc9 on tbl8.PK=tbl9.FK

left outer join tbl10 as tbc10 on tbl9.PK=tbl10.FK

where tbl1.col1='some particular column value'

Group By tbl1.col1

Order tbl1.col1

;

I am writing the sql query but it will depend on your table structure . How many there is PK and FK in your each table.

select tbl1.col1,tbl2.col2,tbl3.col3,
tbl4.col4,tbl5.col5,tbl6.col6,tbl7.col7,tbl8.col8,
tbl9.col9,tbl10.col10

from tbl1.col1 as tbc1 

left outer join tbl2.col2 as tbc2 on tbl1.PK=tbl2.FK
left outer join tbl3 as tbc3 on tbl2.PK=tbl3.FK
left outer join tbl4 as tbc4 on tbl3.PK=tbl4.FK
left outer join tbl5 as tbc5 on tbl4.PK=tbl5.FK
left outer join tbl6 as tbc6 on tbl5.PK=tbl6.FK
left outer join tbl7 as tbc7 on tbl6.PK=tbl7.FK
left outer join tbl8 as tbc8 on tbl7.PK=tbl8.FK
left outer join tbl9 as tbc9 on tbl8.PK=tbl9.FK
left outer join tbl10 as tbc10 on tbl9.PK=tbl10.FK

where tbl1.col1='some particular column value'
Group By tbl1.col1
Order tbl1.col1;

I am writing the sql query but it will depend on your table structure . How many there is PK and FK in your each table.

1
source | link

select tbl1.col1,tbl2.col2,tbl3.col3, tbl4.col4,tbl5.col5,tbl6.col6,tbl7.col7,tbl8.col8, tbl9.col9,tbl10.col10

from tbl1.col1 as tbc1

left outer join tbl2.col2 as tbc2 on tbl1.PK=tbl2.FK

left outer join tbl3 as tbc3 on tbl2.PK=tbl3.FK

left outer join tbl4 as tbc4 on tbl3.PK=tbl4.FK

left outer join tbl5 as tbc5 on tbl4.PK=tbl5.FK

left outer join tbl6 as tbc6 on tbl5.PK=tbl6.FK

left outer join tbl7 as tbc7 on tbl6.PK=tbl7.FK

left outer join tbl8 as tbc8 on tbl7.PK=tbl8.FK

left outer join tbl9 as tbc9 on tbl8.PK=tbl9.FK

left outer join tbl10 as tbc10 on tbl9.PK=tbl10.FK

where tbl1.col1='some particular column value'

Group By tbl1.col1

Order tbl1.col1

;

I am writing the sql query but it will depend on your table structure . How many there is PK and FK in your each table.