Paul --
*^%@#&^%@# typos!!!! :-)
OK....I mispelled instructor and forgot a semi-colon...sorry....lemme know if this works :)
CREATE SQL VIEW myview AS ;
SELECT ls!payment.*,ls!instructor.* FROM payment ;
LEFT JOIN ls!instructor ON ls!payment.pay_inst=ls!instructor.ins_inst ;
LEFT JOIN ls!customer ON ls!payment.pay_acct=ls!customer.cus_acct
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05