Share this Page URL

Chapter 9. Extending Your Use of Queries > Using Outer Joins and Self-Joins - Pg. 330

Extending Your Use of Queries 330 8. Close the ExpenseReport query, but don't save the changes to the query. Here is the SQL statement created when the query uses a left outer join: SELECT MarketingCampaigns.CampaignID, MarketingCampaigns.Country, CampaignExpenses.ExpenseType, CampaignExpenses.AmountSpent, CampaignExpenses.DatePurchased FROM MarketingCampaigns LEFT JOIN CampaignExpenses ON MarketingCampaigns.CampaignID = CampaignExpenses.CampaignID