Dictionary, Encyclopedia and Thesaurus - The Free Dictionary

1,762,810,392 visitors served.

forum mailing list For webmasters

New: Language forums

Dictionary/
thesaurus

Medical
dictionary

Legal
dictionary

Financial
dictionary

Acronyms

Idioms

Encyclopedia

Wikipedia
encyclopedia

inner join

0.04 sec.

inner join

See join.

(database)

inner join - (Commonly "join", but see also "outer join") A relational database operation which selects rows from two tables such that the value in one column of the first table also appears in a certain column of the second table.

An example in SQL:

select * from A, B where A.x = B.y

The column names (x and y in this example) are often, but not necessarily, the same.

How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.

?Page tools

Printer friendly
Cite / link

? Mentioned in

? References in periodicals archive

join	outer join

The INNER JOIN statement begins by searching for a match on the Customer ID values between the Customers and Orders tables.

When querying databases, you've got to ask the right question by Hunton, James E. / Journal of Accountancy

Encyclopedia browser

? Full browser

inner class
inner core
inner ear
inner function
inner harbor
inner hearth
Inner Hebrides
inner join
inner keel
inner Lagrangian point
inner mantle
inner marker
inner measure
Inner Mongolia
Inner Mongolian Autonomous Region

Inner Harbor, Baltimore
Inner Harbor, Baltimore
Inner Harbor, Syracuse
Inner Harbour
Inner Harbour ferry services, Sydney
Inner Harbour Hospital
Inner Healing
Inner Healing Movement
inner hearth
Inner Hebridean
Inner Hebridean
Inner Hebridean
Inner Hebrides
Inner Hebrides
Inner Hebrides
Inner Hebrides

Inner Heliospheric Sentinel
Inner House
Inner House
Inner House of the Court of Session
Inner House of the Court of Session
Inner Housing
Inner Jedi Circle
Inner jib
inner join
Inner Kartli
inner keel
Inner labia
Inner labia
Inner labia
inner Lagrangian point
Inner Landscapes
inner layer of glomerular capsule

Inner Layer Via Hole
Inner Life
Inner Light
Inner Light
Inner Light
Inner Light
Inner limiting membrane
Inner Line
Inner London
Inner London Crown Court
Inner London Education Authority
Inner London Education Authority
Inner London Probation Service
Inner London Sessions House
Inner London Sessions House Crown Court
Inner London Weighting

Free Tools:	For surfers: Free toolbar & extensions \| Word of the Day \| Help For webmasters: Free content \| Linking \| Lookup box \| Double-click lookup \| Partner with us

Disclaimer | Privacy policy | Feedback | Copyright © 2009 Farlex, Inc.

All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. Terms of Use.