Equi join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone give a simple definition of what an equi join is? The text book I
am using isn't really clear on how to create one.

Thanks
CoachBarkerOJPW
 
Equi is Equal.

An equi join is a standard join where tablea.Fielda = TableB.FieldB.
That is the values of fields in the two tables are exactly the same.

A non-equi join is one such as the following where the two fields are
not necessarily exactly equal

TableA.FieldA LIKE TableB.FieldB & "*"

or

TableA.FieldA = TableB.FieldB * 20

or

TableA.FieldA = Left(TableB.FieldB,3)
 
So if in table:

tableA
Fred
Sherry
Bill
Scott
Lulu

tableB
John
Bart
Fred
Wiliam
Sherry

equi join
Fred
Sherry

Is this correct

Thanks
CoachBarkerOJPW
 
Yup.

So if in table:

tableA
Fred
Sherry
Bill
Scott
Lulu

tableB
John
Bart
Fred
Wiliam
Sherry

equi join
Fred
Sherry

Is this correct

Thanks
CoachBarkerOJPW
Click to expand...

Yup.
 
The results are what you would get if you joined the two tables with an
equi-join.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top