By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Right outer join help

P: n/a
K k

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

Please help me to resolve this problem.


*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.