In relational database management, to match one table (file) against another based on some condition creating a third table with data from the matching tables. For example, a customer table can be joined with an order table creating a table for all customers who purchased a particular product.
The default type of join is known as an "inner" join. It produces a resulting record if there is a matching condition. For example, matching shipments with receipts would produce only those shipments that have been received. On the other hand, an "outer" join using that example would create a record for every shipment whether or not it was received. The data for received items would be attached to the shipments, and empty, or null, fields would be attached to shipments without receipts. See also DOS Join.
A Simple Join
This example matches the sales table against the product table based on product number to derive the product description.
The default type of join is known as an "inner" join. It produces a resulting record if there is a matching condition. For example, matching shipments with receipts would produce only those shipments that have been received. On the other hand, an "outer" join using that example would create a record for every shipment whether or not it was received. The data for received items would be attached to the shipments, and empty, or null, fields would be attached to shipments without receipts. See also DOS Join.
A Simple Join
This example matches the sales table against the product table based on product number to derive the product description.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- CRM 2.0 = The Conversation - But First....The Intro
- This is my first post for ZDNET. I'm back from a 10 day cruise to the Caribbean - had a great time - came back to the economy worse than what I left - though gas prices are great - and I'm feeling relaxed anyway - so I thought it...
- Blog posts 2008-11-18
- Webcast: Demo of Dell EqualLogic's award winning PS Family of intelligent, iSCSI-based storage solutions
- Join Dell for a one-hour live presentation and product demonstration of the award-winning PS Family of intelligent, iSCSI-based storage solutions. Upcoming dates and times include all times Eastern DT: Nov 18, 2008 12:00 pm Nov 20, 2008 3:00 pm Nov 25, 2008...
- Webcasts 2008-11-18
- Live Webcast: 5 Best Practices for Modernizing your Enterprise Portal
- Modern enterprise portals offer superior user experience, greater individual and team productivity along with reduced development and support costs. Learn how to get more business value out of your existing enterprise portal using 5 proven best practices. This webcast will show how you can modernize your portal through...
- Webcasts 2008-11-18
- Oh Mamma.com: SEC charges Mark Cuban with insider trading; Cuban responds
- Updated: The Securities and Exchange Commission said Monday that it has charged Mark Cuban with insider trading for selling 600,000 shares of Mamma.com. Specifically, the SEC says that search engine Mamma.com, known today as Copernic, invited Cuban--owner of the Dallas Mavericks and former Yahoo and Broadcast.com exec--to...
- Blog posts 2008-11-17
- BearingPoint's Q3 earnings call - part 1
- To BE or not BE Several news groups and Wall Street firms covered BearingPoint's BE Q3 results this week but one point was not well covered, if at all. Look at this bullet point that is at the bottom of a list of points BE...
- Blog posts 2008-11-14
- Engineering, tech 'suddenly sexy' for college grads
- As the financial crisis deepens, science and math graduates of top colleges and universities who once flocked to investment banking are now looking to jobs in engineering and technology. Sexy science? Indeed. The article, which appears in BusinessWeek, details how the fall of the...
- Blog posts 2008-11-14
- IT failures town hall: Boston, December 3
- Come join top AMR Research analyst, Jonathan Yarmis, and me for an informal IT failures meetup in Boston on December 3. I'll bake fresh muffins and bring the coffee. by Michael Krigsman
- Blog posts 2008-11-13
- Participate in the TechRepublic Smartphone webcast now
- Just a heads-up that I will be participating in the Smartphone Applications and Services over on TechRepublic in a minute or so (starting at 11 am PST) so if you are interested in talking about mobile phones or participating in this live webcast please join me, Josh, and the others....
- Blog posts 2008-11-13
- Wikispaces Webinar - quick note
- A quick note from Wikispaces, via Classroom 2.0: The folks from Wikispaces are running a Classroom 2.0 LIVE Elluminate session tonight on how to get started with educational wikis. This a chance to learn from other educators who are using wikis in education. ...
- Blog posts 2008-11-13
- Getting started with iPhone development
- I've been doing Android development for some time, and before that I experimented with Palm and Blackberry, so I figured it was time for some hands-on iPhone programming as well. In this article I'd like to share a few of my initial experiences. Apple released the first...
- Blog posts 2008-11-13
- Is 'racetrack memory' at heart of IBM-Apple-Papermaster dispute?
- Could IBM's objections to Mark Papermaster's plans to join Apple be linked to so-called racetrack memory, a technology that would store a lot more content on an iPod? That leap was touted by Electronista, which makes its case based on an April story in the Times Online....
- Blog posts 2008-11-13
- Challenging Silicon Valley to put poverty into a museum . . .
- I'm not washing my right hand for a while because I used it to shake the hand of Muhammad Yunus, 2006 Nobel Peace Prize recipient and a person that I've held in the highest regard for many years. Mr Yunus gave the keynote speech at the Tech Museum's Tech...
- Blog posts 2008-11-13
- Live Webcast: Taking the Next Step in Secure Access - Achieving Granular Control
- In tough economic times, businesses need to be efficient, flexible and productive. IT is under pressure to ensure that applications and other business-critical information resources are broadly accessible. To drive topline growth and achieve bottom line efficiencies, virtually everything should be accessible to everyone regardless of their physical location...
- Webcasts 2008-11-13
- Social network for CEOs – best practices
- The Best & Worst of Business Networks Yesterday, I spoke with Ken Ross, the serial entrepreneur who has launched several successful software firms (e.g., Ross Systems, Pillar). Ken's a really nice fellow and someone whose company and counsel I value. I called Ken...
- Blog posts 2008-11-12
- Live Webcast: YouTube's 75 Percent Solution: Closing Down Illegal Videos
- Two years ago, illegal use of professionally created video was rampant on the Web, particularly on video sharing sites such as YouTube. Among those most visibly affected was NBC Universal, which asked YouTube to take down the infamous "Lazy Sunday" video that came from Saturday Night Live, after 5 million...
- Webcasts 2008-11-12
- Live Webcast: Reduce the Risk of Email Downtime and Lower Your Total Cost of Ownership
- Email has become the most pervasive channel for business communication yet despite large enterprise investments in replication, mirroring, and tape backup systems, email systems continue to fail. While natural and man-made disasters can lead to email outages, new data shows that email systems are more frequently brought down by technological...
- Webcasts 2008-11-11
- Live Webcast: The Mobile Workforce: Who is it? What's driving it? How do you manage it?
- As the mobile workforce trend continues to grow (IDC predicts there will be 1 billion mobile workers by 2011), business managers and organizations need to embrace practices and technologies that support this movement and enable workers to communicate and collaborate effectively over long distances. Join the live...
- Webcasts 2008-11-11
- Why aren't we all using Wikispaces?
- While there are plenty of tools for creating Wikis, Wikispaces happens to have a great interface and provides unlimited ad-free pages for K-12 educational purposes. It took about two days for me to upgrade a free wiki that I created to the "Plus" account that the company...
- Blog posts 2008-11-10
- The IBM-Apple-Papermaster triangle: How far does a non-compete go?
- The courtroom tug-of-war between IBM and Mark Papermaster is getting nasty. Papermaster responded Friday to IBM's attempts to prevent him from taking over the iPod unit at Apple. Papermaster argued that IBM doesn't compete with Apple in consumer electronics. IBM reiterated that Papermaster violated a non-compete agreement. Now a judge...
- Blog posts 2008-11-10
- From Chapter Three: The Windows Culture
- From Chapter Three: The Windows CultureYour definition of a video game console ...... must be any device on which games can be played. Cell phiones are thus the most popular consoles.For the term to mean anything, this defintion from Microsoft search is better:Definition of: video game console A specialized...
- Discussion threads 2008-11-07
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
Fusion
- There’s a new energy coming from the people of AMD. Its the power of Fusion.
- Learn about the power of fusion at work and the industry-changing impact of accelerated computing.
-
- View AMD video, case studies, blogs, forums, and more on ZDNet »
-
