Theta joins

1 - About

A theta join is a join that links tables based on a relationship other than equality between two columns. A theta join could use any operator other than the “equal” operator.

2 - Example

The following example and procedure show you how to create a theta join that uses the “Between” operator.

3 - The join properties

  • Bookmark "Theta joins" at del.icio.us
  • Bookmark "Theta joins" at Digg
  • Bookmark "Theta joins" at Ask
  • Bookmark "Theta joins" at Google
  • Bookmark "Theta joins" at StumbleUpon
  • Bookmark "Theta joins" at Technorati
  • Bookmark "Theta joins" at Live Bookmarks
  • Bookmark "Theta joins" at Yahoo! Myweb
  • Bookmark "Theta joins" at Facebook
  • Bookmark "Theta joins" at Yahoo! Bookmarks
  • Bookmark "Theta joins" at Twitter
  • Bookmark "Theta joins" at myAOL
dat/bobj/theta_joins.txt · Last modified: 2010/05/24 17:51 by gerardnico