SQL Editor

SQL Left Join Example

Task:

List all suppliers and their products, including suppliers with no products.
Click here for details on Left Join.
 
 78 Records
CompanyName ProductName
Exotic Liquids Chai
Exotic Liquids Chang
Exotic Liquids Aniseed Syrup
New Orleans Cajun Delights Chef Anton's Cajun Seasoning
New Orleans Cajun Delights Chef Anton's Gumbo Mix
New Orleans Cajun Delights Louisiana Fiery Hot Pepper Sauce
New Orleans Cajun Delights Louisiana Hot Spiced Okra
Grandma Kelly's Homestead Grandma's Boysenberry Spread
Grandma Kelly's Homestead Uncle Bob's Organic Dried Pears
Grandma Kelly's Homestead Northwoods Cranberry Sauce
Tokyo Traders Mishi Kobe Niku
Tokyo Traders Ikura
Tokyo Traders Longlife Tofu
Cooperativa de Quesos 'Las Cabras' Queso Cabrales
Cooperativa de Quesos 'Las Cabras' Queso Manchego La Pastora
Mayumi's Konbu
Mayumi's Tofu
Mayumi's Genen Shouyu
Pavlova, Ltd. Pavlova
Pavlova, Ltd. Alice Mutton
Pavlova, Ltd. Carnarvon Tigers
Pavlova, Ltd. Vegie-spread
Pavlova, Ltd. Outback Lager
Specialty Biscuits, Ltd. Teatime Chocolate Biscuits
Specialty Biscuits, Ltd. Sir Rodney's Marmalade
Specialty Biscuits, Ltd. Sir Rodney's Scones
Specialty Biscuits, Ltd. Scottish Longbreads
PB Knäckebröd AB Gustaf's Knäckebröd
PB Knäckebröd AB Tunnbröd
Refrescos Americanas LTDA Guaraná Fantástica
Heli Süßwaren GmbH & Co. KG NuNuCa Nuß-Nougat-Creme
Heli Süßwaren GmbH & Co. KG Gumbär Gummibärchen
Heli Süßwaren GmbH & Co. KG Schoggi Schokolade
Plutzer Lebensmittelgroßmärkte AG Rössle Sauerkraut
Plutzer Lebensmittelgroßmärkte AG Thüringer Rostbratwurst
Plutzer Lebensmittelgroßmärkte AG Wimmers gute Semmelknödel
Plutzer Lebensmittelgroßmärkte AG Rhönbräu Klosterbier
Plutzer Lebensmittelgroßmärkte AG Original Frankfurter grüne Soße
Nord-Ost-Fisch Handelsgesellschaft mbH Nord-Ost Matjeshering
Formaggi Fortini s.r.l. Gorgonzola Telino
Formaggi Fortini s.r.l. Mascarpone Fabioli
Formaggi Fortini s.r.l. Mozzarella di Giovanni
Norske Meierier Geitost
Norske Meierier Gudbrandsdalsost
Norske Meierier Flotemysost
Bigfoot Breweries Sasquatch Ale
Bigfoot Breweries Steeleye Stout
Bigfoot Breweries Laughing Lumberjack Lager
Svensk Sjöföda AB Inlagd Sill
Svensk Sjöföda AB Gravad lax
Svensk Sjöföda AB Röd Kaviar
Aux joyeux ecclésiastiques Côte de Blaye
Aux joyeux ecclésiastiques Chartreuse verte
New England Seafood Cannery Boston Crab Meat
New England Seafood Cannery Jack's New England Clam Chowder
Leka Trading Singaporean Hokkien Fried Mee
Leka Trading Ipoh Coffee
Leka Trading Gula Malacca
Lyngbysild Rogede sild
Lyngbysild Spegesild
Zaanse Snoepfabriek Zaanse koeken
Zaanse Snoepfabriek Chocolade
Zaanse Snoepfabriek Stroopwafels
Karkki Oy Maxilaku
Karkki Oy Valkoinen suklaa
Karkki Oy Lakkalikööri
G'day, Mate Manjimup Dried Apples
G'day, Mate Filo Mix
G'day, Mate Perth Pasties
Ma Maison Tourtière
Ma Maison Pâté chinois
Pasta Buttini s.r.l. Gnocchi di nonna Alice
Pasta Buttini s.r.l. Ravioli Angelo
Escargots Nouveaux Escargots de Bourgogne
Gai pâturage Raclette Courdavault
Gai pâturage Camembert Pierrot
Forêts d'érables Sirop d'érable
Forêts d'érables Tarte au sucre
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.