Can you do a “Join of a Join”? Like if I have three tables: a, b, and c, and ‘a’ and ‘b’ are connected via foreign key, and ‘b’ and ‘c’ are connected via foreign key, and I’m querying table ‘a’… Can I do a join of table a->b, and THEN a join of table b->c? Does that make sense? (Sorry if this is a noob question).
Related topics
Topic | Replies | Views | Activity | |
---|---|---|---|---|
How do you do a 3 table join? | 0 | 100 | February 21, 2008 | |
MySQL joins and linking tables | 0 | 79 | February 25, 2008 | |
MySQL Query many-to-many (i think) | 10 | 116 | June 17, 2008 | |
Sql Help | 0 | 133 | August 3, 2007 | |
Reversing Join | 0 | 36 | September 1, 2008 |