sql server - Equal Field in Sql -

How to search two tables in the same city with mobile number

  SELECT top 1 candidate Candidate from Circle Mobile not included in the Candidate, Serial Inner Joiner, Serial. Id = Employer Serial. ID where the candidate certificates. Lieutenant; & Gt; EmployerSerials.City and EmployerSerials.MobileNo = '000000000'    
 
 
  SELECT TOP 1 Candidates Serial.Officers recruitment on the appointment of candidates to join the candidates from the candidates for the candidates. IG = Employer Services Candidate and Candidate Certificates = Employeeships. City where Employer Serial .mobile no = '000000000'