SELECT * FROM CustomersWHERE City IN ('Paris','London'); | CustomerID | CustomerName | ContactName | ContactTitle | Address | City | Region | PostalCode | Country | Phone | Fax |
|---|---|---|---|---|---|---|---|---|---|---|
| AROUT | Around the Horn | Thomas Hardy | Sales Representative | 120 Hanover Sq. | London | WA1 1DP | UK | (171) 555-7788 | (171) 555-6750 | |
| BSBEV | B's Beverages | Victoria Ashworth | Sales Representative | Fauntleroy Circus | London | EC2 5NT | UK | (171) 555-1212 | ||
| CONSH | Consolidated Holdings | Elizabeth Brown | Sales Representative | Berkeley Gardens 12 Brewery | London | WX1 6LT | UK | (171) 555-2282 | (171) 555-9199 | |
| EASTC | Eastern Connection | Ann Devon | Sales Agent | 35 King George | London | WX3 6FW | UK | (171) 555-0297 | (171) 555-3373 | |
| NORTS | North/South | Simon Crowther | Sales Associate | South House 300 Queensbridge | London | SW7 1RZ | UK | (171) 555-7733 | (171) 555-2530 | |
| PARIS | Paris spécialités | Marie Bertrand | Owner | 265, boulevard Charonne | Paris | 75012 | France | (1) 42.34.22.66 | (1) 42.34.22.77 | |
| SEVES | Seven Seas Imports | Hari Kumar | Sales Manager | 90 Wadhurst Rd. | London | OX15 4NB | UK | (171) 555-1717 | (171) 555-5646 | |
| SPECD | Spécialités du monde | Dominique Perrier | Marketing Manager | 25, rue Lauriston | Paris | 75016 | France | (1) 47.55.60.10 | (1) 47.55.60.20 |