yes this is the exact input. i m sorry it was mismatched earlier. The output should have only one row for common fields..

thanx