inner join

You are here: irt.org | FOLDOC | inner join

<database> (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.

(1998-11-23)

Nearby terms: inline image « INMOS transputer « inner class « inner join » inner product » InnovAda » inode

FOLDOC, Topics, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, ?, ALL