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

