Try this query :)
select condet.ContactID,condet.ContactName,condet.EMailID,tc.CName,ts.Name,condet.ContactNumber from tblContactDetails as condet
inner join tblCountry as tc on condet.CountryID = tc.CountryID
inner join tblState as ts on tc.CountryID = ts.CountryID