RE: Can SQL "simulate" a multiple format logical file with a join?

Gentlemen,

Thank you for your responses.

What I intended to imply in the original post, was that the subfile lists
invoice and payment records for a given student, so I set lower limits on
District, School, and Student, and read-equal by this partial key to get
all the records for the student.  So, yes, there won't be many (relatively
speaking) records for a given student, but there will be a very large
number of records in the files.

I think I see what happens with UNION, but I will read up on that and
experiment with that before bothering with more questions.

One question I do have concerns the permanancy of this view / index. 
Would I create this once and use it much like I would a logical file?  Or
would I have to do the SELECT everytime a different student is selected? 
My entire experience with SQL is SELECT, UPDATE, & DELETE.  

I presume that, by no mention of it in your replies, adding a join of
another file to both FT310 & FT320, and using one of its fields to
sequence records is not a problem?

GA


        
                
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover