Posts by henrique1977 • 26 points

• 1

  votes

  1

  answer

  415

  views

  A: Mysql Join check IF data does not exist in another table

  /** selecionar todos que nao sao amigos do id=1 **/ SELECT * FROM perfil p WHERE id!=1 AND id NOT IN ( SELECT pa.id FROM perfil p JOIN amigos a ON…

  mysql

  answered 6 years, 3 months ago henrique1977 26