Results 1 to 3 of 3

Thread: Really general MySQL JOIN question

  1. #1

    Really general MySQL JOIN question

    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).
    Proud Montanadian
    You want a toe? I can get you a toe... Hell, I can get you a toe by three o'clock this afternoon, with nail polish.

  2. #2
    jwilliam's Avatar
    476
    posts
    An intellectual carrot!
    I believe mysql would make a temporary table from the a->b join and then that resultant table would be joined with table c...

  3. #3
    Yeah, I just tried it out and it worked like a dream
    Proud Montanadian
    You want a toe? I can get you a toe... Hell, I can get you a toe by three o'clock this afternoon, with nail polish.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012