Help for this page

Select Code to Download


  1. or download this
    TABLE users
    userid   firstname    lastname
    ...
    
    TABLE msg
    msg_id    msg_from     msg_to      received   age  city  country
    
  2. or download this
    SELECT users.userid, users.firstname, users.lastname, msg.age, msg.cit
    +y, msg.country FROM msg
    JOIN users ON users.userid = msg.msg_from
    WHERE msg.msg_to = ? 
      AND msg.received IS NULL