[RBASE-L] - Re: SQL Question

[A. Razzak Memon]

At 11:20 PM 8/12/2009, Fogelson, Steve wrote:

I don't use Left Outer Joins very often, so I would like to ask the list.

Steve,

Here is an example of using LEFT OUTER JOIN based on RRBYW16.

-- Start
SET ERROR MESSAGE 677 OFF
DROP VIEW RBG90_LftOutrJoin
SET ERROR MESSAGE 677 ON
CREATE VIEW `RBG90_LftOutrJoin` +
(TransID,TotalPrice) AS  +
SELECT t1.TransID,(SUM(t2.Price)) +
FROM InvoiceHeader t1 +
LEFT OUTER JOIN InvoiceDetail t2 ON t2.TransID = t1.TransID +
GROUP BY t1.TransID
COMMENT ON VIEW `RBG90_LftOutrJoin` IS +
'RBG90 - Sample Left Outer Join View'
RETURN
-- End

Hope that helps!

Very Best R:egards,

Razzak.