I have three tables within a report
the order table
orderid Date
101 31/03/2004
102 31/03/2004
103 31/03/2004
104 31/03/2004
The Job Table
OrderID Job type
101 1
101 2
102 1
103 2
103 3
104 1
104 4
The Job Type table
job type id Job type description
1-----------------Jobt1
2-----------------jobT2
3-----------------jobt3
4-----------------jobt4
I need to produce 2 reports that will return the following
all the orders that contain job type 1 alongside the other job types associated with that order
eg
orderid job type des
101 Jobt1
101 Jobt2
102 Jobt1
104 jobt1
104 jobt4
and another report that produces the output all the orders that do not contain a jobtype of 1
orderid jobtype des
103 jobt2
103 jobt3
these will be extracted for specific dates
what are the joins and select criteria I will need for each report
the order table
orderid Date
101 31/03/2004
102 31/03/2004
103 31/03/2004
104 31/03/2004
The Job Table
OrderID Job type
101 1
101 2
102 1
103 2
103 3
104 1
104 4
The Job Type table
job type id Job type description
1-----------------Jobt1
2-----------------jobT2
3-----------------jobt3
4-----------------jobt4
I need to produce 2 reports that will return the following
all the orders that contain job type 1 alongside the other job types associated with that order
eg
orderid job type des
101 Jobt1
101 Jobt2
102 Jobt1
104 jobt1
104 jobt4
and another report that produces the output all the orders that do not contain a jobtype of 1
orderid jobtype des
103 jobt2
103 jobt3
these will be extracted for specific dates
what are the joins and select criteria I will need for each report