Count function giving duplicate record count

I am trying to execute a join query with count function but i am getting duplicate record count also. How can i omit that duplicate record count and get exact value.

please provide sample data or a screen shot of what you are talking about?


In this exception count is the count function which i used.

Please post create table statement(s) and sample data in the form of inserts, what you've tried so far and the desired result.

Sorry i am not executing Create table, i am executing select query.

please provide source data for us to test with.

create table #pavan(field1 int, field2 varchar(50))

insert into #pavan
select 1, 'sample data' union
select 2, 'sample data2' 

I you want more help please post the requested so people can help without guessing.