RE: SQL table joins: Join vs. Where

I understand what you are saying.  But the text sure didn't look that way.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


|-----------------------------+-------------------------------------------|
|   "Fisher, Don"             |                                           |
|   <Dfisher@xxxxxxxxxxxxxxxxx|                                           |
|   >                         |                                         To|
|   Sent by:                  |                                    "'Midra|
|   midrange-l-bounces@midrang|                                    nge    |
|   e.com                     |                                    Systems|
|                             |                                    Technic|
|   08/12/2004 10:15 AM       |                                    al     |
|                             |                                    Discuss|
|         Please respond to   |                                    ion'"  |
|         Midrange Systems    |                                    <midran|
|       Technical Discussion  |                                    ge-l@mi|
|      <midrange-l@xxxxxxxxxxx|                                    drange.|
|                m>           |                                    com>   |
|                             |                                         cc|
|                             |                                           |
|                             |                                     Fax to|
|                             |                                           |
|                             |                                    Subject|
|                             |                                    RE: SQL|
|                             |                                    table  |
|                             |                                    joins: |
|                             |                                    Join   |
|                             |                                    vs.    |
|                             |                                    Where  |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|                             |                                           |
|-----------------------------+-------------------------------------------|






I believe the statement regarding the primary file meant the key fields.
Join logical files may only have key fields from the primary file.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
"This is a case where SQL & Query/400 both have an advantage over join
logicals, because the joins are not limited to linking to the primary."
<clip>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.