druagord — Tue, 30 Mar 2004 16:33:35 +0000

Also since you only need to join on fid this query should be better

SELECT tid, threads.fid, forums.fal, sub, forums.title FROM threads LEFT JOIN forums ON threads.fid=forums.fid;

druagord — Tue, 30 Mar 2004 16:20:28 +0000

shouldn't the fields from the forum table be called like this forums.title,forums.fal

m3rajk — Mon, 29 Mar 2004 15:02:42 +0000

help me understand why it's getting

Quote: mysql> select tid, threads.fid, fal, sub, title from threads natural join forums;
+-----+-----+-----+-------------------------+----------------------+
| tid | fid | fal | sub | title |
+-----+-----+-----+-------------------------+----------------------+
| 4 | 3 | 0 | Saluting | Fakes |
| 6 | 5 | 1 | EVERYONE | Shouts |
| 10 | 8 | 1 | what not to wear on TLC | Fashion & Style |
| 13 | 1 | 5 | Test | Mod Review |
| 16 | 2 | 0 | test | Problems/Suggestions |
| 17 | 4 | 1 | double checking | General/Misc |
+-----+-----+-----+-------------------------+----------------------+
6 rows in set (0.00 sec)

instead of

Quote: mysql> select tid, threads.fid, fal, sub, title from threads natural join forums;
+-----+-----+-----+---------------------------+----------------------+
| tid | fid | fal | sub | title |
+-----+-----+-----+---------------------------+----------------------+
| 1 | 1 | 5 | point of this forum | Mod Review |
| 2 | 2 | 0 | Interests | Problems/Suggestions |
| 3 | 3 | 0 | about calling others fake | Fakes |
| 4 | 3 | 0 | Saluting | Fakes |
| 5 | 4 | 1 | Hey! | General/Misc |
| 6 | 5 | 1 | EVERYONE | Shouts |
| 7 | 2 | 0 | testing guest posting | Problems/Suggestions |
| 9 | 2 | 0 | logging in | Problems/Suggestions |
| 10 | 8 | 1 | what not to wear on TLC | Fashion & Style |
| 11 | 4 | 1 | Yo | General/Misc |
| 12 | 4 | 1 | Just testing... | General/Misc |
| 13 | 1 | 5 | Test | Mod Review |
| 14 | 4 | 1 | Mistakes and Errors | General/Misc |
| 15 | 4 | 1 | dev to demo to.... | General/Misc |
| 16 | 2 | 0 | test | Problems/Suggestions |
| 17 | 4 | 1 | double checking | General/Misc |
+-----+-----+-----+---------------------------+----------------------+
17 rows in set (0.00 sec)

so that i can get it to that second one

s0da — Mon, 29 Mar 2004 05:15:08 +0000

er.. what is the question?