Posts by henrique1977 • 26 points
1 post
-
1
votes1
answer415
viewsA: 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…
mysqlanswered henrique1977 26