Data Types

ID #1013

What is INNER join?

The VIEW structure defaults to a "left outer join", where all records for the VIEW's primary file are retrieved whether the secondary file named in the JOIN structure contains any related records or not.Specifying the INNER attribute on the JOIN creates "inner join"so that only those primary file records with related secondary file records are retrieved. Innert join is more efficient than outer join

Tags: VIEW, inner join

Related entries: -

Last update: 2007-07-13 16:31
Author: Aleksey Timkov
Revision: 1.0

Digg it! Print this record Send to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this entry:

Average rating: 5 out of 5 (1 Votes )

completely useless 1 2 3 4 5 most valuable

You can comment on this entry