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:17] Joakim Forsgren |
u9_databaser [2013-01-24 15:20] Joakim Forsgren |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== SELECT JOIN frågor på ett enkelt form ====== | ====== SELECT JOIN frågor på ett enkelt form ====== | ||
Det finns 3 tabeller i databasen jf_select som heter: | Det finns 3 tabeller i databasen jf_select som heter: | ||
- | Threads, | + | lab5_Threads, |
- | Items, | + | lab5_Items, |
- | Users\\ | + | lab5_Users\\ |
logga in med jf_select: | logga in med jf_select: | ||
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 | ||
+ | */ | ||
+ | </ | ||