Forum Discussion

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago

RIGHT OUTER JOIN DIRECT QUERY

I am using the direct query by using 2 tables and I want to use RIGHT OUTER JOIN to do a merge. But it is taking a long time to merge the 2 tables and it is effecting the production environment. The ...
Need Help
sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
8 years ago

I did the reverse as you said but I am missing some rows from the second table

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

It should not be the case. Obviously, you need only the matching row from the second table. If some rows misisng means,  how about the values of joining columns for those records ? Are they matching?

 

Thanks
Raj