Employees
Employee#	Name	Job Description	Job Rate
1	Jorenson,Mike	Artist II	$42.50
2	Howsworth,Elizabeth	Editor	$32.75
3	Rancine, Michael	Photograher	$55.00
4	Elkins, Naomi	Artist II	$44.50
5	Waters, Ann Marie	Artist I	$27.50
6	Devons, Robert	Senior Editor	$52.80
7	James, Miranda	Artist II	$42.50
8	Ballack, Stephanie	Editor	$37.20
9	Moreno, Mandy	Ad Exec	$125.00

Job1
taskid#	Employee#	Minutes	Date
1	1	23	7 /3 /2006
2	3	13	7 /3 /2006
3	4	17	7 /8 /2006
4	3	5	7 /9 /2006
5	3	15	7 /10/2006
6	8	8	7 /10/2006
7	7	5	7 /10/2006
8	1	12	7 /12/2006
9	7	6	7 /13/2006

Job2
taskid#	Employee#	Minutes	Date
1	3	20	7 /1 /2006
2	4	10	7 /3 /2006
3	1	15	7 /3 /2006
4	3	5	7 /5 /2006
5	3	15	7 /9 /2006
6	9	12	7 /9 /2006
7	7	22	7 /10/2006
8	7	15	7 /11/2006

Employees and Job1 Inner Join
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job1.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	1	1	23	7 /3 /2006
1	Jorenson,Mike	Artist II	$42.50	8	1	12	7 /12/2006
3	Rancine, Michael	Photograher	$55.00	2	3	13	7 /3 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /9 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /10/2006
4	Elkins, Naomi	Artist II	$44.50	3	4	17	7 /8 /2006
7	James, Miranda	Artist II	$42.50	7	7	5	7 /10/2006
7	James, Miranda	Artist II	$42.50	9	7	6	7 /13/2006
8	Ballack, Stephanie	Editor	$37.20	6	8	8	7 /10/2006

Employees and Job2 Inner Join
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job2.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	3	1	15	7 /3 /2006
3	Rancine, Michael	Photograher	$55.00	1	3	20	7 /1 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /5 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /9 /2006
4	Elkins, Naomi	Artist II	$44.50	2	4	10	7 /3 /2006
7	James, Miranda	Artist II	$42.50	7	7	22	7 /10/2006
7	James, Miranda	Artist II	$42.50	8	7	15	7 /11/2006
9	Moreno, Mandy	Ad Exec	$125.00	6	9	12	7 /9 /2006

Employees and Job1 Outer Join relative to Employees
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job1.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	1	1	23	7 /3 /2006
1	Jorenson,Mike	Artist II	$42.50	8	1	12	7 /12/2006
2	Howsworth,Elizabeth	Editor	$32.75
3	Rancine, Michael	Photograher	$55.00	2	3	13	7 /3 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /9 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /10/2006
4	Elkins, Naomi	Artist II	$44.50	3	4	17	7 /8 /2006
5	Waters, Ann Marie	Artist I	$27.50
6	Devons, Robert	Senior Editor	$52.80
7	James, Miranda	Artist II	$42.50	7	7	5	7 /10/2006
7	James, Miranda	Artist II	$42.50	9	7	6	7 /13/2006
8	Ballack, Stephanie	Editor	$37.20	6	8	8	7 /10/2006
9	Moreno, Mandy	Ad Exec	$125.00

Employees and Job1 Outer Join relative to Job1
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job1.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	1	1	23	7 /3 /2006
1	Jorenson,Mike	Artist II	$42.50	8	1	12	7 /12/2006
3	Rancine, Michael	Photograher	$55.00	2	3	13	7 /3 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /9 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /10/2006
4	Elkins, Naomi	Artist II	$44.50	3	4	17	7 /8 /2006
7	James, Miranda	Artist II	$42.50	7	7	5	7 /10/2006
7	James, Miranda	Artist II	$42.50	9	7	6	7 /13/2006
8	Ballack, Stephanie	Editor	$37.20	6	8	8	7 /10/2006

Employees and Job2 Outer Join relative to Employees
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job2.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	3	1	15	7 /3 /2006
2	Howsworth,Elizabeth	Editor	$32.75
3	Rancine, Michael	Photograher	$55.00	1	3	20	7 /1 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /5 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /9 /2006
4	Elkins, Naomi	Artist II	$44.50	2	4	10	7 /3 /2006
5	Waters, Ann Marie	Artist I	$27.50
6	Devons, Robert	Senior Editor	$52.80
7	James, Miranda	Artist II	$42.50	7	7	22	7 /10/2006
7	James, Miranda	Artist II	$42.50	8	7	15	7 /11/2006
8	Ballack, Stephanie	Editor	$37.20
9	Moreno, Mandy	Ad Exec	$125.00	6	9	12	7 /9 /2006

Employees and Job2 relative to Job2
Employees.Employee#	Name	Job Description	Job Rate	taskid#	Job2.Employee#	Minutes	Date
1	Jorenson,Mike	Artist II	$42.50	3	1	15	7 /3 /2006
3	Rancine, Michael	Photograher	$55.00	1	3	20	7 /1 /2006
3	Rancine, Michael	Photograher	$55.00	4	3	5	7 /5 /2006
3	Rancine, Michael	Photograher	$55.00	5	3	15	7 /9 /2006
4	Elkins, Naomi	Artist II	$44.50	2	4	10	7 /3 /2006
7	James, Miranda	Artist II	$42.50	7	7	22	7 /10/2006
7	James, Miranda	Artist II	$42.50	8	7	15	7 /11/2006
9	Moreno, Mandy	Ad Exec	$125.00	6	9	12	7 /9 /2006