Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Outer Join (ActionScript)
Title: Outer Join Language: ActionScript
Description: Joining 2 tables where not matches will still show Views: 174
Author: Tom Baggett Date Added: 3/12/2010
Copy Code   
SELECT tblEZ.CompanyName, tblEZ.Address, tblEZ.City, tblEZ.State, tblEZ.Zip, tblEZ.CustomerNum, tblEZ.VicCust, Over25AfterChicago.Branch, 
               Over25AfterChicago.SalesRep, Over25AfterChicago.CustomerNum AS Expr1, Over25AfterChicago.Customer, Over25AfterChicago.CurrYTD
FROM  tblEZ RIGHT OUTER JOIN
               Over25AfterChicago ON tblEZ.CustomerNum = Over25AfterChicago.CustomerNum
WHERE (Over25AfterChicago.CurrYTD > 100000)
ORDER BY tblEZ.CustomerNum DESC