join file in query400

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

I've never done too much with join files, so this may be just my
inexperience.  I created a join between our sales and orders files in order
to facilitate calculating orders net of returns. (Orders are in the orders
file and returns are in the sales file.)  I'm running a query as I type that
is collecting net orders for a group of products.  I'm running it
interactively (F5) and have been staring a message that announces that the
query is building a copy of the join file.

Is this normal behavior.  Both of the files that are joined have buckets for
13 weeks of various kinds of data for each store for every item code.  (It's
made for reports, not transactional data.)

Is this peculiar?  Sure took a long time. 
+---
| 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
+---