I don't think I've ever used a left outer join yet, but from my instructions here's an example. You would just add the "create view viewname (colname list) as" in front of it:
SELECT t2.TransId, + MAX(t1.NetAmount), SUM(t2.ExtPrice) + FROM TransMaster t1 LEFT OUTER JOIN + TransDetail t2 ON + t1.TransId = t2.TransId + GROUP BY t2.TransId HAVING + SUM(t2.ExtPrice) <> MAX(t1.NetAmount) Karen > How do you make a Left Outer Join in a view for V8? > > >
