SQL(embedded or not) and OPNQRYF

["Billy Rowe" <billyrowe@xxxxxxx>]

Does SQL and/or OpnQryF filter records before the joining of 2 files?

For example,  If I wanted to join a Customer table to the Transaction table
only for let's say customer number 222.

Would the system join the file first and then filter the records OR
would the system filter the records first and then join only the
corresponding
customer(222) to it's transactions for presentation to the screen or a
Program?

TIA,
Billy


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---