[RBASE-L] - Re: Making left outer join in a view

[A. Razzak Memon]

At 05:54 PM 9/29/2009, Jack Mathis wrote:

How do you make a Left Outer Join in a view for V8?

Jack,

Here you go ...

-- R:BASE Turbo V-8:
01. Use Query Wizard
02. Use Command Line
    -- Example:
    CONNECT RRBYW15
    SET ERROR MESSAGE 677 OFF
    DROP VIEW Transactions_OuterJoin
    SET ERROR MESSAGE 677 ON
    CREATE VIEW Transactions_OuterJoin AS +
    SELECT t2.TransID, SUM(t3.Price) +
    FROM InvoiceHeader t2 +
    LEFT OUTER JOIN InvoiceDetail t3 ON +
    t3.TransID = t2.TransID +
    GROUP BY t2.TransID
    COMMENT ON VIEW Transactions_OuterJoin IS +
    'Invoice Header and Transactions Summary'
    RETURN

-- R:BASE eXtreme 9.0 (64)
01. Use Query Wizard
02. Use Query Builder
    You have to try this to appreciate the interface!
03. Use Command Line
    -- Example:
    CONNECT RRBYW16
    SET ERROR MESSAGE 677 OFF
    DROP VIEW Transactions_OuterJoin
    SET ERROR MESSAGE 677 ON
    CREATE VIEW Transactions_OuterJoin AS +
    SELECT t2.TransID, SUM(t3.Price) +
    FROM InvoiceHeader t2 +
    LEFT OUTER JOIN InvoiceDetail t3 ON +
    t3.TransID = t2.TransID +
    GROUP BY t2.TransID
    COMMENT ON VIEW Transactions_OuterJoin IS +
    'Invoice Header and Transactions Summary'
    RETURN

Very Best R:egards,

Razzak.