In your tables has records for to return all informations? You problem maybe is that any table not have some records. Maybe alter inner join for left join in some relation should to resolve your problem.
Kindly mark this post as "Answer", if it helped you.
pierrefrc
Participant
947 Points
201 Posts
Re: join sp problem
Apr 23, 2012 12:36 PM|LINK
In your tables has records for to return all informations? You problem maybe is that any table not have some records. Maybe alter inner join for left join in some relation should to resolve your problem.