Trying something new.  Can I use 2 left outer joins?   Contact is my main 
table, may or may not be a matching ID in the Client and People table, but I'm 
getting a syntax error.   It works fine with just t1 and t2, errors when I add 
in the t3 syntax:

CREATE VIEW vContactAll AS SELECT t1.*, t2.*, t3.* +
  FROM Contact t1 +
  LEFT OUTER JOIN client t2 ON t1.id = t2.id +
  LEFT OUTER JOIN people t3 ON t1.id = t3.id


Karen

Reply via email to