Hi,
I need your help to resolve this problem. I have written a right outer
join query between 2 indipendent tables as follows.
select b.Account_desc, b.Account, a.CSPL_CSPL from Actual_data_final a
right outer join Actual_account_Tbl b on a.account_desc = b.account_desc
where (a.source_type = 'TY02' or a.source_type is null) and (a.month =
'2ND HALF' or a.month is null) and (a.year = 2004 or a.year is null) and
(a.product = 'NP' or a.product is null) order by b.Sno
But the problem is I have few records in table Actual_account_Tbl but do
not match the condition "a.account_desc = b.account_desc".
As per right outer join, I suppose to get those records as a result of
the above query with null values of a.CSPL_CSPL. But it is not
displaying.
Please help me to resolve this problem.
Regards,
Omav
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!