query

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  January 8, 2008 at 10:47 am

  #63141

  I have table

  tblemp(empjob,emprole)

  empjob emprole

  1 Mngr

  1 Mngr

  1 Mngr

  2 clerk

  2 clerk

  2 clerk

  How can I find records if there is any records that are not matching like (empjob=1,empname=clerk)

• David.Poole

  SSC Guru

  Points: 76037

  More actions

  January 8, 2008 at 12:42 pm

  #765872

  SELECT *

  FROM tblEmp

  WHERE empjob=1

  AND emprole <>'clerk'

  LinkedIn Profile