Hi,

I am pretty new to views and I am having a problem building a view with three tables. The three tables are Payments, Customer, and Instructor. I would like a view that lists every payment and includes Customer and Instructor information. I go into the view designer and add the payment table and then the customer file the relation I create is a left join with payment.pay_acct = customer.cus_acct. I then add the instructor table with a left join on payment.pay_inst = instructor.ins_inst. The resulting sql statement follows:

SELECT Payment.*, Instructor.*;
 FROM  ls!payment LEFT OUTER JOIN ls!instructor;
    INNER JOIN ls!customer ;
   ON  Payment.pay_acct = Customer.cus_acct ;
   ON  Payment.pay_inst = Instructor.ins_inst

However when I try to save the view I get an error "SQL: Column 'Pay_Acct' is not found."

Thanks,

Paul