inserire tabella relationship in una functions

[searedone]

Allora ho fatto varie prove ma nulla .. spero che qualcuno possa aiutarmi

"SELECT * FROM
    messages INNER JOIN users ON (messages.uid_fk=uid)
    WHERE
    messages.uid_fk IN  ( SELECT user_1 FROM relationship AS R WHERE R.user_2 = '$uid' AND R.amico = 'S' ) OR messages.uid_fk IN  ( SELECT user_2 FROM relationship AS R WHERE R.user_1 = '$uid' AND R.amico = 'S')  $morequery order by messages.msg_id desc 

Pagine bianca non mi pronta i risultati


Così errore pagina prorpio bianca

"SELECT * FROM
    messages INNER JOIN users ON (messages.useruid=user.uid)
     messages INNER JOIN relationship ON ( SELECT user_1 FROM relationship AS R WHERE R.user_2 = '$uid' AND R.amico = 'S' ) 
     M.uid_fk IN
     messages INNER JOIN relationship ON ( SELECT user_2 FROM relationship AS R WHERE R.user_1 = '$uid' AND R.amico = 'S')
    WHERE
   messages.uid_fk='$uid' AND messages.uid_fk = users.uid $morequery order by M.msg_id desc limit " 

cosi mi da il seguente errore

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'messages INNER JOIN relationship ON ( messages.relationshipid = relationship.id' at line 3

$query = mysql_query( "SELECT * FROM
    messages INNER JOIN users ON (messages.useruid=user.uid )
     messages INNER JOIN relationship ON ( messages.relationshipid = relationship.id AND user_2 = '$uid' AND amico = 'S' ) 
    OR messages.uid_fk IN
     messages INNER JOIN relationship ON ( messages.relationshipid = relatioship.id user_1 = '$uid' AND amico = 'S' )
    WHERE
   messages.uid_fk='$uid' AND messages.uid_fk = users.uid $morequery order by M.msg_id desc limit " .$this->perpage) or die(mysql_error());