Equi join

[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

 

[John Spencer]

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)

 

[Guest]

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

 

[Jason Lepack]

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

Yup.

 

[John Spencer]

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