Northwind › Views
Customer and Suppliers by City view
120 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| City | CompanyName | ContactName | Relationship |
|---|---|---|---|
| Aachen | Drachenblut Delikatessen | Sven Ottlieb | Customers |
| Albuquerque | Rattlesnake Canyon Grocery | Paula Wilson | Customers |
| Anchorage | Old World Delicatessen | Rene Phillips | Customers |
| Ann Arbor | Grandma Kelly's Homestead | Regina Murphy | Suppliers |
| Annecy | Gai pâturage | Eliane Noz | Suppliers |
| Barcelona | Galería del gastrónomo | Eduardo Saavedra | Customers |
| Barquisimeto | LILA-Supermercado | Carlos González | Customers |
| Bend | Bigfoot Breweries | Cheryl Saylor | Suppliers |
| Bergamo | Magazzini Alimentari Riuniti | Giovanni Rovelli | Customers |
| Berlin | Alfreds Futterkiste | Maria Anders | Customers |
| Berlin | Heli Süßwaren GmbH & Co. KG | Petra Winkler | Suppliers |
| Bern | Chop-suey Chinese | Yang Wang | Customers |
| Boise | Save-a-lot Markets | Jose Pavarotti | Customers |
| Boston | New England Seafood Cannery | Robb Merchant | Suppliers |
| Brandenburg | Königlich Essen | Philip Cramer | Customers |
| Bruxelles | Maison Dewey | Catherine Dewey | Customers |
| Bräcke | Folk och fä HB | Maria Larsson | Customers |
| Buenos Aires | Cactus Comidas para llevar | Patricio Simpson | Customers |
| Buenos Aires | Océano Atlántico Ltda. | Yvonne Moncada | Customers |
| Buenos Aires | Rancho grande | Sergio Gutiérrez | Customers |
| Butte | The Cracker Box | Liu Wong | Customers |
| Campinas | Gourmet Lanchonetes | André Fonseca | Customers |
| Caracas | GROSELLA-Restaurante | Manuel Pereira | Customers |
| Charleroi | Suprêmes délices | Pascale Cartrain | Customers |
| Cork | Hungry Owl All-Night Grocers | Patricia McKenna | Customers |