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
You can comment on this entry