Ok it is working fine just i have to change table and column name while joining the table of state child.
select condet.ContactID,condet.ContactName,condet.EMailID,tc.CName,ts.Name,condet.ContactNumber from tblContactDetails as condet
left outer join tblCountry as tc on condet.CountryID = tc.CountryID
left outer join tblState as ts on condet.stateid = ts.stateid
Now it is working fine.