按另一个表列排序表？

Question

I have this query:

$q = "SELECT * FROM user 
WHERE sec='1' AND reg_by='".$_SESSION['login_username']."' 
ORDER BY date DESC LIMIT $startrow, 30 ";

I have another table which stores appointments, it has a column named meet.

How can I sort this query by meet?

Not all data at users are in other table.

Answer 1

You can use the below query. Replace another_table with your original table name :

$q = "SELECT u.* FROM user AS u LEFT JOIN another_table AS at ON u.userid = at.userid WHERE u.sec='1' AND u.reg_by='".$_SESSION['login_username']."' ORDER BY at.meet DESC LIMIT $startrow, 30 ";