In your first post you said Unique No is the primary key. By default in SQL Server this is a clustered index, unless you specify otherwise at creation time.

Can you give some table definitions and sample data, as described in the first link of my signature. That way it will be easier to find the correct SQL statements to use.