Thanks Razzak! Got it to work! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, August 12, 2009 10:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL Question
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. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
