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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- LG and AT&T join forces on X120 netbook
- LG announced today the availability of the X120 Netbook with a AT&T contract. For pricing and details, Previously only available in Europe, the LG X120 will be hitting American shores soon no date specified for $180 at Radio Shack and select "The...
- Blog posts 2009-11-23
- Data Robotics debuts enterprise-ready DroboElite, five-bay Drobo S
- Data Robotics on Monday announced the enterprise-ready DroboElite and the five-bay Drobo S, which both join the standard 4-bay Drobo and the popular eight-bay DroboPro. by Andrew Nusca
- Blog posts 2009-11-23
- Allok Video Joiner 4.4.1117 (Windows)
- Allok Video Joiner is a powerful tool to join or merge multiple AVI, Divx, XviD, MPEG, WMV, ASF, RM, MOV, 3GP, MP4, FLV files into one large file in various format. You can add an unlimited number of video files to the list and easily rearrange their order if needed...
- Software downloads 2009-11-22
- MKVtools 2.2.3 (Mac)
- MKVtools is a collection of tools used to manipulate .mkv and .ogm video files. It's primary purpose is to convert .ogm and .mkv files into more user friendly formats - either .avi files, .mp4 files or as individually extracted track files. MKVtools is trialware - only $4.99 for full functionality,...
- Software downloads 2009-11-22
- Want to see the HTC HD2? Join me at the PSHUG meeting next Tuesday
- One of the benefits about writing about mobile phones is that I get the opportunity to play with a LOT of cool devices for a few weeks at a time. Years ago I was a regular attendee to the monthly Puget Sound Handheld User Group PSHUG meetings, but life as...
- Blog posts 2009-11-21
- Insignia NS-L26Q-10A
- Off brand Insignia a decent TV? YES!For sometime now, I have been searching for a small screen LCD TV that had a great picture and decent sound. If a great picture were the only criteria, finding one of these babies would be a simple task; but throw in the...
- Discussion threads 2009-11-21
- PeaZip 2.8 (Windows)
- PeaZip is a free, open source file and archive manager for 32 and 64 bit Windows and Linux. It is available either as installable and portable application not needing installation. Full support: 7Z, 7Z-sfx, ARC/WRC, BZ2/TBZ2, Custom user defined, GZ/TGZ, PAQ/ZPAQ, PEA, QUAD/BALZ, split, TAR, UPX, ZIP. Open, browse, extract,...
- Software downloads 2009-11-21
- Wondershare Video to Flash Converter Pro 4.0.1.2 (Windows)
- Wondershare Video to Flash Converter Pro is your ideal solution to convert DVD video to Flash. With this Flash Video Converter Pro, you can convert various Video AVI to Flash, MPEGMPG to Flash, WMV to Flash, MOV to Flash, DVDvob to Flash, Video to SWF, MOD to Flash, TODJVC Vidicon...
- Software downloads 2009-11-20
- Do we need a 'beautiful mess' in operating systems? Yup
- To make a good soup, you've got to stir the pot...Ok, sure - it turns cloudy, short-term. Just be sure to filter it or let it settle, before serving.Whereas the classic 'design-by-committee' model so often fails, its always useful to have multiple, talented teams working on similar projects, independently. With...
- Discussion threads 2009-11-19
- Reduce Cost and Improve Service Levels with Application Performance Monitoring Simplification
- Organizations are feeling the pressure of economic uncertainty. They strive to closely align IT infrastructure to the business and also face challenges to reduce costs. While virtually every IT organization has multiple management solutions in place, the unfortunate truth is that most companies are struggling to develop a product mix...
- Webcasts 2009-11-19
- Two more utilities join IBM-backed smart grid coalition
- IBM's smart grid vision continues to gain clarity; utilities from Brazil and the Netherlands join the vendor's best practices "coalition." by Heather Clancy
- Blog posts 2009-11-18
- Salesforce Chatter: Facebook for the Enterprise
- Salesforce is announcing today a Salesforce Chatter, an enteprise collaboration application akin to Facebook. The move puts SalesForce in competition with offerings from other providers, including IBM Lotus. Here's what's being delivered. Features: Profiles: Just like profiles on popular consumer-oriented social networking sites, Salesforce Chatter profiles include...
- Blog posts 2009-11-18
- Royal Navy gets creative in attracting engineers - develop online game
- the govt needs to fix up its actwhy would anyone want to join engineering when the wall street guys paid million for doing nothing. As long as the pay compensation is not fixed engineers will be quitting to join financial industry.Call of duty 7: Modern Warfare 3?Could be.Engineering is much...
- Discussion threads 2009-11-18
- Yahoo's dwindling search share: Time to panic?
- Typical MicrosoftThis is normal business practice for MS. Partner up with someone, take what they need, then discard them.Ask anyone from RealNetworks how their partnership went.It's about search.Wow, it looks like the volume of search users use the search engine that delivers better results.Google search is better than Bing...
- Discussion threads 2009-11-18
- Web and Newspaper Journalist joins FCC
- Commissioner Copps announces Journalist to join FCC as Media advisor. by Doug Hanchard
- Blog posts 2009-11-18
- Little Space Duo 1.0 (Mac)
- Little Space Duo is a puzzle-based arcade game starring an unusual pair of heroes - a little girl and a small robot. They have found themselves in trouble on a huge spaceship and need to join forces to sort out the situation. Join them on a mission through the spaceship...
- Software downloads 2009-11-18
- Dynamic AI Personal Edition 6.3.23 (Windows)
- Dynamic AI Personal Edition allows you create powerful interactive reports and dashboards all running in a browser. The amazing new Automated Intelligence feature creates reports and dashboard fully automatically for you by analyzing your database's contents. Add advanced options like filtering, sorting, grouping and totaling to your reports with just...
- Software downloads 2009-11-18
- TextPipe Standard 8.4.4 (Windows)
- Slam-dunk the most challenging code or Web site edit tasks with TextPipe - a powerful text-processing utility that combines more than 100 conversion, translation and filtering operations on multiple text or binary files. Update text using search and replace, which supports perl pattern matching, sounds-like matching, edit-distance matching and search/replace...
- Software downloads 2009-11-18
- TextPipe Pro 8.4.4 (Windows)
- Slam-dunk the most challenging edit tasks with TextPipe Pro a text-processing utility that combines 270+ conversion, transformation, extraction and report mining operations on multiple text or binary files. Update Web sites using multi-line EasyPattern search and replace, and new Unicode find and replace with patterns. Restrict changes to line or...
- Software downloads 2009-11-18
- Delicious - Emily's Holiday Season 1.0 (Mac)
- Deck the halls with love and joy in Delicious - Emily's Holiday Season, a wonderful time management sequel to warm up your holidays! It's winter in Snuggford and Emily is preparing for her family's holiday party at a cozy little lodge. While making arrangements, the new owner quickly recognizes her...
- Software downloads 2009-11-18
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Innovate your business' process model, play against the market, compete against others on our scoreboards and WIN! Try INNOV8 2.0: A BPM Simulator
- Enabling Real-World Business Transformation through IBM Service Management Read the EMA Analyst Report
