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 |
|---|---|---|---|
| Cowes | Island Trading | Helen Bennett | Customers |
| Cunewalde | QUICK-Stop | Horst Kloss | Customers |
| Cuxhaven | Nord-Ost-Fisch Handelsgesellschaft mbH | Sven Petersen | Suppliers |
| Elgin | Hungry Coyote Import Store | Yoshi Latimer | Customers |
| Eugene | Great Lakes Food Market | Howard Snyder | Customers |
| Frankfurt | Plutzer Lebensmittelgroßmärkte AG | Martin Bein | Suppliers |
| Frankfurt a.M. | Lehmanns Marktstand | Renate Messner | Customers |
| Genève | Richter Supermarkt | Michael Holz | Customers |
| Graz | Ernst Handel | Roland Mendel | Customers |
| Göteborg | PB Knäckebröd AB | Lars Peterson | Suppliers |
| Helsinki | Wilman Kala | Matti Karttunen | Customers |
| I. de Margarita | LINO-Delicateses | Felipe Izquierdo | Customers |
| Kirkland | Trail's Head Gourmet Provisioners | Helvetius Nagy | Customers |
| Kobenhavn | Simons bistro | Jytte Petersen | Customers |
| Köln | Ottilies Käseladen | Henriette Pfalzheim | Customers |
| Lander | Split Rail Beer & Ale | Art Braunschweiger | Customers |
| Lappeenranta | Karkki Oy | Anne Heikkonen | Suppliers |
| Leipzig | Morgenstern Gesundkost | Alexander Feuer | Customers |
| Lille | Folies gourmandes | Martine Rancé | Customers |
| Lisboa | Furia Bacalhau e Frutos do Mar | Lino Rodriguez | Customers |
| Lisboa | Princesa Isabel Vinhos | Isabel de Castro | Customers |
| London | Around the Horn | Thomas Hardy | Customers |
| London | B's Beverages | Victoria Ashworth | Customers |
| London | Consolidated Holdings | Elizabeth Brown | Customers |
| London | Eastern Connection | Ann Devon | Customers |