complex else

[jonniejoejonson]

$sql="SELECT

maxTable.maxMessageId,

a.*,

b.userFirstname, b.userLastname, b.userImage

FROM (SELECT MAX(messageId) AS maxMessageId, threadId FROM mail_messages WHERE fromUserId!='".$userId."' GROUP BY threadId) maxTable

INNER JOIN mail_messages AS a ON maxTable.maxMessageId=a.messageId

INNER JOIN users AS b ON a.fromUserId=b.userId

WHERE a.threadId='1' OR a.threadId='2'

ORDER BY a.messageId DE SC";

 

This is hard to explain... but

The point is if there is no selection from the subquery where...

fromUserId!='".$userId."'

i would like to do a differnet subquery instead..

is there a way to do this regards J.

[jskywalker]

could u extend the sub-query wit a union?

 

( SELECT * from mail_message WHERE fromUserId!='".$userId."' GROUP BY threadId

UNION

  SELECT ...... ) maxTable

 

 

But i think it will not get better performance, so i would try to figure out a better way