Hi Ppl,

how to create a query on this 2 tables

Table1

ID Date Remarks
1 06/01/05 Remarks1
1 06/02/05 Remarks2
1 06/03/05 Remarks3
2 06/01/05 Remarks1
2 06/02/05 Remarks2
2 06/03/05 Remarks3
2 05/05/05 Remarks1


Table2

Date Remarks
06/01/05 Remarks4
06/02/05 Remarks4
06/03/05 Remarks4
06/04/05 Remarks5
06/05/05 Remarks4
06/06/05 Remarks4
06/07/05 Remarks4
06/08/05 Remarks5

the result should look like this

ID Date Remarks
1 06/01/05 Remarks1
1 06/02/05 Remarks2
1 06/03/05 Remarks3
1 06/04/05 Remarks5
1 06/05/05 Remarks4
1 06/06/05 Remarks4
1 06/07/05 Remarks4
1 06/08/05 Remarks5
2 06/01/05 Remarks1
2 06/02/05 Remarks2
2 06/03/05 Remarks3
2 06/04/05 Remarks5
2 05/05/05 Remarks1
2 06/06/05 Remarks4
2 06/07/05 Remarks4
2 06/08/05 Remarks5


thanks in advance....

Jeff