Not getting Desired Data in List

[nsaha]

Hi All,
I need a help.

Today I faced a problem.I have  put data items from different tables in a list.Then I got values only for those data items whose values are available in two or three data subjects because of inner join.But I want to get also those data(it will be 0 of course because the data is not available in all data subjects) which have no matching values in other tables.So how can we show that???

[HalfBloodPrince]

You need outer Join.