Trying to do a Left Join in SQL Query

[TheMayhem]

$item_info = mysql_query("SELECT * FROM `sales` where buyerid=0 AND datecompleted=0 AND type=1 AND ($time-datestarted)/86400 <= 5 ORDER BY $sort $order LIMIT $membersdisplay,$membersnum");

while ($item = mysql_fetch_array($item_info)) {


$move = mysql_fetch_array(mysql_query("SELECT * FROM `items` where id=$item[moveid]"));


echo "
<tr><td valign='bottom'>$item[date]</td><td valign='bottom'><input type='radio' name='move' value='$item[id]'></input>$type $move[name]</td>
<td valign='bottom'>$move[damage]</td><td valign='bottom'><a href='member.php?id=$seller[id]'>$seller[username]</a></td><td valign='bottom'>" . number_format($item[price]) . "</td></tr>";


}


From what I have been told, a left join is what I need to do but I'm really confused beyond belief on how to do it. As you can see above I have a normal looking while loop. What I want to do is order everything by $move[name]. The problem is right now I have to use a fetch array inside the loop to do so. How can I take that first query and sort everything by something inside the query such as $move[name]?

[Andreas]

SELECT * FROM sales
LEFT JOIN items ON (items.id=sales.moveid)
WHERE buyerid=0 AND datecompleted=0 AND type=1 AND ($time-datestarted)/86400 <= 5
ORDER BY items.name ASC
LIMIT $membersdisplay,$membersnum

[TheMayhem]

That worked to perfection! Thanks :)