SQL Editor

SQL Outer Full Join Example

Task:

Match all customers and suppliers by country.
Click here for details on Outer Join.
 
 195 Records
FirstName LastName CustomerCountry SupplierCountry CompanyName
NULL NULL NULL Australia Pavlova, Ltd.
NULL NULL NULL Australia G'day, Mate
NULL NULL NULL Japan Tokyo Traders
NULL NULL NULL Japan Mayumi's
NULL NULL NULL Netherlands Zaanse Snoepfabriek
NULL NULL NULL Singapore Leka Trading
Patricio Simpson Argentina NULL NULL
Yvonne Moncada Argentina NULL NULL
Sergio Gutiérrez Argentina NULL NULL
Georg Pipps Austria NULL NULL
Roland Mendel Austria NULL NULL
Pascale Cartrain Belgium NULL NULL
Catherine Dewey Belgium NULL NULL
Bernardo Batista Brazil Brazil Refrescos Americanas LTDA
Lúcia Carvalho Brazil Brazil Refrescos Americanas LTDA
Janete Limeira Brazil Brazil Refrescos Americanas LTDA
Aria Cruz Brazil Brazil Refrescos Americanas LTDA
André Fonseca Brazil Brazil Refrescos Americanas LTDA
Mario Pontes Brazil Brazil Refrescos Americanas LTDA
Pedro Afonso Brazil Brazil Refrescos Americanas LTDA
Paula Parente Brazil Brazil Refrescos Americanas LTDA
Anabela Domingues Brazil Brazil Refrescos Americanas LTDA
Elizabeth Lincoln Canada Canada Ma Maison
Elizabeth Lincoln Canada Canada Forêts d'érables
Yoshi Tannamuri Canada Canada Ma Maison
Yoshi Tannamuri Canada Canada Forêts d'érables
Jean Fresnière Canada Canada Ma Maison
Jean Fresnière Canada Canada Forêts d'érables
Jytte Petersen Denmark Denmark Lyngbysild
Palle Ibsen Denmark Denmark Lyngbysild
Pirkko Koskitalo Finland Finland Karkki Oy
Matti Karttunen Finland Finland Karkki Oy
Mary Saveley France France Aux joyeux ecclésiastiques
Mary Saveley France France Escargots Nouveaux
Mary Saveley France France Gai pâturage
Paul Henriot France France Aux joyeux ecclésiastiques
Paul Henriot France France Escargots Nouveaux
Paul Henriot France France Gai pâturage
Dominique Perrier France France Aux joyeux ecclésiastiques
Dominique Perrier France France Escargots Nouveaux
Dominique Perrier France France Gai pâturage
Marie Bertrand France France Aux joyeux ecclésiastiques
Marie Bertrand France France Escargots Nouveaux
Marie Bertrand France France Gai pâturage
Daniel Tonini France France Aux joyeux ecclésiastiques
Daniel Tonini France France Escargots Nouveaux
Daniel Tonini France France Gai pâturage
Annette Roulet France France Aux joyeux ecclésiastiques
Annette Roulet France France Escargots Nouveaux
Annette Roulet France France Gai pâturage
Carine Schmitt France France Aux joyeux ecclésiastiques
Carine Schmitt France France Escargots Nouveaux
Carine Schmitt France France Gai pâturage
Frédérique Citeaux France France Aux joyeux ecclésiastiques
Frédérique Citeaux France France Escargots Nouveaux
Frédérique Citeaux France France Gai pâturage
Laurence Lebihan France France Aux joyeux ecclésiastiques
Laurence Lebihan France France Escargots Nouveaux
Laurence Lebihan France France Gai pâturage
Janine Labrune France France Aux joyeux ecclésiastiques
Janine Labrune France France Escargots Nouveaux
Janine Labrune France France Gai pâturage
Martine Rancé France France Aux joyeux ecclésiastiques
Martine Rancé France France Escargots Nouveaux
Martine Rancé France France Gai pâturage
Sven Ottlieb Germany Germany Heli Süßwaren GmbH & Co. KG
Sven Ottlieb Germany Germany Plutzer Lebensmittelgroßmärkte AG
Sven Ottlieb Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Maria Anders Germany Germany Heli Süßwaren GmbH & Co. KG
Maria Anders Germany Germany Plutzer Lebensmittelgroßmärkte AG
Maria Anders Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Hanna Moos Germany Germany Heli Süßwaren GmbH & Co. KG
Hanna Moos Germany Germany Plutzer Lebensmittelgroßmärkte AG
Hanna Moos Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Peter Franken Germany Germany Heli Süßwaren GmbH & Co. KG
Peter Franken Germany Germany Plutzer Lebensmittelgroßmärkte AG
Peter Franken Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Alexander Feuer Germany Germany Heli Süßwaren GmbH & Co. KG
Alexander Feuer Germany Germany Plutzer Lebensmittelgroßmärkte AG
Alexander Feuer Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Renate Messner Germany Germany Heli Süßwaren GmbH & Co. KG
Renate Messner Germany Germany Plutzer Lebensmittelgroßmärkte AG
Renate Messner Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Philip Cramer Germany Germany Heli Süßwaren GmbH & Co. KG
Philip Cramer Germany Germany Plutzer Lebensmittelgroßmärkte AG
Philip Cramer Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Horst Kloss Germany Germany Heli Süßwaren GmbH & Co. KG
Horst Kloss Germany Germany Plutzer Lebensmittelgroßmärkte AG
Horst Kloss Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Henriette Pfalzheim Germany Germany Heli Süßwaren GmbH & Co. KG
Henriette Pfalzheim Germany Germany Plutzer Lebensmittelgroßmärkte AG
Henriette Pfalzheim Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Rita Müller Germany Germany Heli Süßwaren GmbH & Co. KG
Rita Müller Germany Germany Plutzer Lebensmittelgroßmärkte AG
Rita Müller Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Karin Josephs Germany Germany Heli Süßwaren GmbH & Co. KG
Karin Josephs Germany Germany Plutzer Lebensmittelgroßmärkte AG
Karin Josephs Germany Germany Nord-Ost-Fisch Handelsgesellschaft mbH
Patricia McKenna Ireland NULL NULL
Paolo Accorti Italy Italy Formaggi Fortini s.r.l.
Paolo Accorti Italy Italy Pasta Buttini s.r.l.
Maurizio Moroni Italy Italy Formaggi Fortini s.r.l.
Maurizio Moroni Italy Italy Pasta Buttini s.r.l.
Giovanni Rovelli Italy Italy Formaggi Fortini s.r.l.
Giovanni Rovelli Italy Italy Pasta Buttini s.r.l.
Guillermo Fernández Mexico NULL NULL
Ana Trujillo Mexico NULL NULL
Antonio Moreno Mexico NULL NULL
Francisco Chang Mexico NULL NULL
Miguel Angel Paolino Mexico NULL NULL
Jonas Bergulfsen Norway Norway Norske Meierier
Zbyszek Piestrzeniewicz Poland NULL NULL
Lino Rodriguez Portugal NULL NULL
Isabel de Castro Portugal NULL NULL
Eduardo Saavedra Spain Spain Cooperativa de Quesos 'Las Cabras'
José Pedro Freyre Spain Spain Cooperativa de Quesos 'Las Cabras'
Diego Roel Spain Spain Cooperativa de Quesos 'Las Cabras'
Martín Sommer Spain Spain Cooperativa de Quesos 'Las Cabras'
Alejandra Camino Spain Spain Cooperativa de Quesos 'Las Cabras'
Christina Berglund Sweden Sweden PB Knäckebröd AB
Christina Berglund Sweden Sweden Svensk Sjöföda AB
Maria Larsson Sweden Sweden PB Knäckebröd AB
Maria Larsson Sweden Sweden Svensk Sjöföda AB
Yang Wang Switzerland NULL NULL
Michael Holz Switzerland NULL NULL
Simon Crowther UK UK Exotic Liquids
Simon Crowther UK UK Specialty Biscuits, Ltd.
Elizabeth Brown UK UK Exotic Liquids
Elizabeth Brown UK UK Specialty Biscuits, Ltd.
Ann Devon UK UK Exotic Liquids
Ann Devon UK UK Specialty Biscuits, Ltd.
Thomas Hardy UK UK Exotic Liquids
Thomas Hardy UK UK Specialty Biscuits, Ltd.
Victoria Ashworth UK UK Exotic Liquids
Victoria Ashworth UK UK Specialty Biscuits, Ltd.
Helen Bennett UK UK Exotic Liquids
Helen Bennett UK UK Specialty Biscuits, Ltd.
Hari Kumar UK UK Exotic Liquids
Hari Kumar UK UK Specialty Biscuits, Ltd.
Helvetius Nagy USA USA New Orleans Cajun Delights
Helvetius Nagy USA USA Grandma Kelly's Homestead
Helvetius Nagy USA USA Bigfoot Breweries
Helvetius Nagy USA USA New England Seafood Cannery
Karl Jablonski USA USA New Orleans Cajun Delights
Karl Jablonski USA USA Grandma Kelly's Homestead
Karl Jablonski USA USA Bigfoot Breweries
Karl Jablonski USA USA New England Seafood Cannery
Jose Pavarotti USA USA New Orleans Cajun Delights
Jose Pavarotti USA USA Grandma Kelly's Homestead
Jose Pavarotti USA USA Bigfoot Breweries
Jose Pavarotti USA USA New England Seafood Cannery
Yoshi Latimer USA USA New Orleans Cajun Delights
Yoshi Latimer USA USA Grandma Kelly's Homestead
Yoshi Latimer USA USA Bigfoot Breweries
Yoshi Latimer USA USA New England Seafood Cannery
John Steel USA USA New Orleans Cajun Delights
John Steel USA USA Grandma Kelly's Homestead
John Steel USA USA Bigfoot Breweries
John Steel USA USA New England Seafood Cannery
Howard Snyder USA USA New Orleans Cajun Delights
Howard Snyder USA USA Grandma Kelly's Homestead
Howard Snyder USA USA Bigfoot Breweries
Howard Snyder USA USA New England Seafood Cannery
Rene Phillips USA USA New Orleans Cajun Delights
Rene Phillips USA USA Grandma Kelly's Homestead
Rene Phillips USA USA Bigfoot Breweries
Rene Phillips USA USA New England Seafood Cannery
Fran Wilson USA USA New Orleans Cajun Delights
Fran Wilson USA USA Grandma Kelly's Homestead
Fran Wilson USA USA Bigfoot Breweries
Fran Wilson USA USA New England Seafood Cannery
Jaime Yorres USA USA New Orleans Cajun Delights
Jaime Yorres USA USA Grandma Kelly's Homestead
Jaime Yorres USA USA Bigfoot Breweries
Jaime Yorres USA USA New England Seafood Cannery
Paula Wilson USA USA New Orleans Cajun Delights
Paula Wilson USA USA Grandma Kelly's Homestead
Paula Wilson USA USA Bigfoot Breweries
Paula Wilson USA USA New England Seafood Cannery
Art Braunschweiger USA USA New Orleans Cajun Delights
Art Braunschweiger USA USA Grandma Kelly's Homestead
Art Braunschweiger USA USA Bigfoot Breweries
Art Braunschweiger USA USA New England Seafood Cannery
Liz Nixon USA USA New Orleans Cajun Delights
Liz Nixon USA USA Grandma Kelly's Homestead
Liz Nixon USA USA Bigfoot Breweries
Liz Nixon USA USA New England Seafood Cannery
Liu Wong USA USA New Orleans Cajun Delights
Liu Wong USA USA Grandma Kelly's Homestead
Liu Wong USA USA Bigfoot Breweries
Liu Wong USA USA New England Seafood Cannery
Carlos González Venezuela NULL NULL
Felipe Izquierdo Venezuela NULL NULL
Manuel Pereira Venezuela NULL NULL
Carlos Hernández Venezuela NULL NULL
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.