When to use JOINs

Posted by waiwai933 on Stack Overflow See other posts from Stack Overflow or by waiwai933
Published on 2010-04-10T06:08:07Z Indexed on 2010/04/10 6:13 UTC
Read the original article Hit count: 132

Filed under:
|

It seems to me that there are two scenarios in which to use JOINs:

  1. When data would otherwise be duplicated
  2. When data from one query would otherwise be used in another query

Are these scenarios right? Are there any other scenarios in which to use JOIN?

© Stack Overflow or respective owner

Related posts about sql

Related posts about join