Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
u9_databaser [2013-01-24 15:18] Joakim Forsgren |
u9_databaser [2013-01-24 15:20] Joakim Forsgren |
||
---|---|---|---|
Line 118: | Line 118: | ||
| 35 | Testtråd | | 35 | Testtråd | ||
| 36 | Lorem ipsum | 1 | 2013-01-24 13:10:11 | 36 | 110 | Praesent orn | 2013-01-24 13:14:17 | Joakim Forsgren | | 36 | Lorem ipsum | 1 | 2013-01-24 13:10:11 | 36 | 110 | Praesent orn | 2013-01-24 13:14:17 | Joakim Forsgren | ||
- | +----------+-------------+--------+---------------------+----------+--------+---------------+---------------------+-----------------------+------------+---------+...</ | + | +----------+-------------+--------+---------------------+----------+--------+---------------+---------------------+-----------------------+------------+---------+...</ |
- | + | SELECT lab5_Threads.*, | |
+ | FROM | ||
+ | ( | ||
+ | select | ||
+ | INNER JOIN lab5_Items USING(UserID) | ||
+ | ORDER BY CreateDate DESC | ||
+ | ) as t1 | ||
+ | RIGHT JOIN lab5_Threads USING(ThreadID) | ||
+ | INNER JOIN lab5_Users ON lab5_Users.UserID=lab5_Threads.UserID | ||
+ | GROUP BY lab5_Threads.ThreadID | ||
+ | */ | ||
+ | </ | ||