Mysql query : join and sort

Question

i'm still learning...i have two database tables

setting: id, uid, deptid
user :  id, uid, name

i want the result to be sort ascending by name from user table

$result = $DB->query("SELECT s.*, u.* FROM ".$myDB->prefix("setting")." AS s LEFT JOIN ".$myDB->prefix("user")." AS u ON s.uid=u.uid ORDER BY u.name ASC");

please advice..Thank you

The following answer will give you all you need. https://stackoverflow.com/a/38578/967853 — Skelly1983, May 26 '17 at 02:12

score 0 · Answer 1 · answered May 26 '17 at 02:18

SELECT setting.*, user.* FROM setting LEFT JOIN user ON setting.uid = user.uid ORDER BY user.name ASC

Also, look in to which join you'll want to be using to get the right data. The venn diagrams on these pages easily represent what data will be shown.

In my experience, it's usually the Inner join I look at working with.

Mysql query : join and sort

1 Answers1