join
2 ResultsDictionary
join
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...
Dictionary
Definition: join
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.
A Simple Join
This example matches the sales table against the product table based on product number to derive the product description.
THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
© 1981-2010 The Computer Language Company Inc. All rights reserved.
Sponsored White Papers, Webcasts & Resources
-
Live Webcast: Getting to Microsoft Office 365: The Right Migration for Your Business
If you've been stuck using bare bones, web-based tools, you'll appreciate the full featured collaboration in MS Office 365. Check out this live webcast to learn more about Microsoft Office 365,...
-
Apple snags ex-OLPC security chief
Former director of security architecture at One Laptop per Child (OLPC) Ivan Krstic has joined Apple to help thwart hacker attacks against the Mac operating system. Krstic, a...
-
Beyond findability: The search for active intelligence
It took a decade of indexing advances such as skip lists and index compression to make indexing practical, and another decade of computing advances to give us billions of searchable documents says...
Additional Results
-
Join HP support expert Tommaso Esmanech for a May 15 live chat on IT support automation
Modern support services need to be able to empower the workers and IT personnel alike to maintain peak control over data centers, and to keep the systems and processes performing reliably at...
-
AOL joins Microsoft as sponsor of Outercurve Foundation
The open-source-focused Outercurve Foundation now has a second major backer, in addition to Microsoft.
-
Facebook CEO Mark Zuckerberg joins Viddy
Facebook co-founder and CEO Mark Zuckerberg has joined Viddy. This is interesting for two reasons: Viddy is growing very quickly, in part thanks to Facebook, and it's also been compared to Instagram.
-
Red Hat and SUSE join IBM in new Linux system, Canonical opts out
While Red Hat and SUSE are throwing their support behind IBM's new Linux POWER servers, Canonical, Ubuntu's parent company, has opted to sit this one out.
-
Join live Twitter chat on Big Data with U.S. CTO Todd Park
U.S. CTO Todd Park will host a live Twitter chat on Tuesday, April 24 to talk about real world uses for Big Data. See how to join the conversation.
-
Google helped with CISPA, joins Cybersecurity Theatre
GOP chair says Google helped with unprecedented snooping bill CISPA, widely opposed by organizations and individuals alike.
-
Samsung's Galaxy Nexus joins Sprint's LTE party on April 22nd: $199
Sprint is adding to its LTE portfolio with its own version of the Galaxy Nexus, which lands on April 22nd.
-
Join me for a deep-dive live discussion on why IT's role may never be the same
One way IT can hasten their responsiveness to business requirements is in their ability to deliver applications to PC faster, better and cheaper.
-
Microsoft joins the fight against child pornography
A digital tool will now be available for use by law enforcement agencies to tackle child pornography.
-
TED Talks joins Netflix's stable of streaming content
With the addition of TEDTalks, Netflix is extending is reach beyond just movies and television shows.
-
Sameer Patel joins SAP and why it matters
Sameer Patel joins SAP. This is important. Here's why.
-
Join HP security expert Tari Schreider for a deep-dive live chat on cloud protection
On March 22, in a free, online, live multimedia "Expert Chat," Dana Gardner will be interviewing Tari Schreider, Chief Security Architect, HP Technology Consulting, on how to prevent security...
-
Google joins Windows 8 browser war with plans for Metro Chrome
Google has confirmed that it plans to join Mozilla in developing a next-generation browser optimized for the Metro style of Windows 8. It's an important validation of the Windows 8 platform from...
-
NVIDIA joins the Linux Foundation
Fluendo, Lineo Solutions, Mocana have just joined the Linux Foundation but the big news is that major graphics chip maker NVIDIA is now officially supporting Linux.
-
Joining the dots in the cloud
Businesses are going to have to connect up all those stovepiped cloud instances they've deployed. New options are emerging, but which ones are going work?
-
Jeremy Lin joins Facebook
Jeremy Lin has joined Facebook. Oh sure, he was probably using the world's most popular social network before, but now he's got a new public account that anyone can Subscribe to.
-
Facebook CEO Mark Zuckerberg joins Pinterest
Facebook co-founder and CEO Mark Zuckerberg has joined Pinterest. He's already more active on it than Google+, and could soon surpass his Twitter activity, but that's not saying much.
-
Joining Kindle Fire and Nook Tablet, Kobo's Vox eReader lands at Best Buy
Kobo's answer to the Nook Touch and Kindle Fire will be sold at Best Buy, the company announced.
The best of ZDNet, delivered
ZDNet Newsletters
Get the best of ZDNet delivered straight to your inbox
Vendor Showcase
