Business 245 ilab7

lab_7_start.accdb

Home >Business & Finance homework help >Accounting homework help >Business 245 ilab7

CityID	CityName
1	Orlando
2	Toronto
3	Calgary
4	Atlanta

CustomerID	LastName	FirstName	City
1	Ward	Bert	2
2	Feldman	Robin	4
3	Smith	Jay	3
4	Russell	Stephanie	1
5	Krause	Tim	1
6	Pinesi	Veronica	2
7	Garrett	Jana	2
8	Beecher	Rick	2
9	Romney	Steve	3
10	Gardner	JP	3
11	Tate	Heather	3
12	Tate	Kim	3
13	Carrabas	Ron	4
14	Crawford	Jake	3
15	Brown	Sheri	4

SELECT [City].[CityID], [City].[CityName] FROM City;

SELECT DISTINCTROW * FROM Customer;

SELECT DISTINCTROW * FROM City;

SELECT DISTINCTROW * FROM Customer;

SELECT [Customer].[CustomerID], [Customer].[LastName], [Customer].[FirstName], [City].[CityName] FROM City INNER JOIN Customer ON City.CityID=Customer.City;