I created a view based on 4 tables: Crseinfo (Course Information), Crsedtl (People enrolled in course), People (Person Info), and Trainer (Trainer/Teacher Info).
There are JOIN's between Crseinfo and Crsedtl on a modulecode and levelcode, Crsedtl and People on a personcode and Crsedtl and Trainer on a trainercode.
The view runs great and saved fine but now when I try and modify it I get the error:
SQL: Column 'TRAINERCODE' is not found.
Trainercode is not a selected field for the view and is only specified in the JOIN. The only info in the view from the Trainer table is a concatenated field of fname+" "+lname. Why is this happening?
Also, even though I can't edit it the view still runs fine.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.