Pictorial representation is of Great help...thanks a ton!!!

Now, in the same tables , I need to add certain conditions:

1. Table A- a column(say TYPE) contains 10 distinct values, and for...

Thanks a ton Luis!!!

I have a doubt, in the last 2 sentences of your code, we are checking if a.ANUM is null, will this work?

Because, if there are no null...