Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
u9_databaser [2013-01-24 15:20] Joakim Forsgren |
u9_databaser [2013-01-30 10:43] Joakim Forsgren |
||
|---|---|---|---|
| Line 131: | Line 131: | ||
| */ | */ | ||
| </ | </ | ||
| + | |||
| + | === Sista frågan från genomgång === | ||
| + | |||
| + | <code SQL> | ||
| + | SELECT *, COUNT(ChangeDate) as N, EMail as ThreadEMail FROM ( | ||
| + | SELECT lab5_Threads.*, | ||
| + | INNER JOIN `lab5_Threads` USING(UserID) | ||
| + | LEFT JOIN lab5_Items | ||
| + | USING (ThreadID) | ||
| + | ORDER BY ChangeDate DESC) as t1 | ||
| + | INNER JOIN lab5_Users USING(UserID) | ||
| + | GROUP BY ThreadID | ||
| + | ORDER BY ChangeDate DESC | ||
| + | |||
| + | </ | ||