Nick,
Thanks, that worked perfectly. It seems to make more sense than the way the designer arranged the code. Now I have a "Template" I can use for future views. Your assistance has made my Monday.:)
Ken
>>I'm attempting to join 4 tables into a view. I've given up on the view designer and am using CREATE SQL. The project is for a workshop that offers classes.
>>I link the class table to the class code table through classid(to pick up the class title).
>>I link the class table to the instructor table through instid(to get the instructor name).
>>I link the class table to the mail (students) table (to get student names).
>>I'm getting the right number of records, everything looks great but the class title, which is the same class title for everything. I have tried eView but just got it yesterday. I've been staring at this too long. Any tips appreciated.
>>
>>
>>CREATE SQL VIEW roster ;
>>AS SELECT New_class.ident, New_class.class, New_class.session,;
>> New_class.class_date, New_class.instid, Classcod.title, Instructor.lname,;
>> Instructor.fname, Mail.lname, Mail.fname;
>> FROM outdoor_woman!instructor INNER JOIN outdoor_woman!new_class;
>> INNER JOIN outdoor_woman!mail;
>> INNER JOIN outdoor_woman!classcod ;
>> ON New_class.classid = Classcod.classid ;
>> ON New_class.ident = Mail.ident ;
>> ON Instructor.instid = New_class.instid
>
>Ken, rearrange SQL this way:
>
>CREATE SQL VIEW roster ;
> AS SELECT New_class.ident, New_class.class, New_class.session,;
> New_class.class_date, New_class.instid, Classcod.title, Instructor.lname,;
> Instructor.fname, Mail.lname, Mail.fname;
> FROM outdoor_woman!instructor ;
> INNER JOIN outdoor_woman!new_class;
> ON Instructor.instid = New_class.instid ;
> INNER JOIN outdoor_woman!mail;
> ON New_class.ident = Mail.ident ;
> INNER JOIN outdoor_woman!classcod ;
> ON New_class.classid = Classcod.classid
>
>Nick