Hi,

instead using all the columns in the group by clause, you can use aggregate function "OVER BY " in the query............

OR

give me the details of the output what u want.....

i have two tables more than 10,000 rows in each table

each from different databases

and also having different number of rows

i want just marely join those tables and render...