out results of a field when there

Discussion in 'MySQL' started by wsoulrc, Aug 27, 2011.

0
  1. #1
    Hello,

    I have these two tables

    tabla juegos
    - id
    - idjuego

    :: 1 - Pokemon
    :: 2 - Lugareños S.A


    tabla stats
    - id
    - idjuego
    - idusuario

    :: 1 - 1 - 1
    :: 1 - 2 - 1
    :: 1 - 1 - 2

    I want to get the games not played, so those who are not in stats. I am as well but not out

    WHO? WHERE¿
     
    wsoulrc, Aug 27, 2011 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    You have users who played certain games and you want??? Users who didn't play a particular game? Games not played?

    You have to define exactly what you want before anyone can start thinking of the code to do it.
     
    Rukbat, Aug 31, 2011 IP