Thanks for your reply Jeff.

I got clear pic .. thanks a lot...

one more doubt Jeff,

both the condition table is empty,

then why the where condition returns 'null'

and

group by condition returns nothing.

can you plz explain me ?