Often during development we find ourselves writing the following kind of query as we're working out what we need and how best to get at it.

select T1.*
  ,T2.*
  ,T3.*
from table1 T1
inner join table2 T2 on T1.pk = T2.fk
inner join table3 T3 on T2.pk = T3.fk

If the tables have a lot of fields it can become frustrating trying to figure out where one ends and the next begins. Try the following to make it easier on yourself as you scroll across your results...

select '>>> T1 >>>' as 'T1'
  ,T1.*
  ,'>>> T2 >>>' as 'T2'
  ,T2.*
  ,'>>> T3 >>>' as 'T3'
  ,T3.*
from table1 T1
inner join table2 T2 on T1.pk = T2.fk
inner join table3 T3 on T2.pk = T3.fk