Select query

[polo]

Hey all,

Ok I'm having a problem running a query, below is description:

TableA has columns
RecievedDate
ResultsID

TableB has columns
SentDate
SentID

TableC has columns
ResultsID
Sent ID

I want to have a result of all values in Table A that have a value of Recieved Date is less than SentDate in TableB, I can link up through table C but I'm not sure on what way would be the best to do this?

Any info really appreciated,

Thanks for reading this

 

[cuttsy]

Can you give a few rows of example data for each table and of the results the query would return

 

[polo]

Can you give a few rows of example data for each table and of the results the query would return

TableA
Recieved Date | Results ID
31/01/2005 | 3
21/05/2006 | 2

TableB
Sent Date | SentID
02/02/2005 | 5
18/05/2006 | 6

TableC
Name | ResultsID | SentID
Example1 | 3 | 5
Example2 | 2 | 6

For the results I would want all data from Table A where RecievedDate is less than TableB.SentDate so my results for the above example would be:

Recieved Date | Results ID
31/01/2005 | 3

Hope this clarifies, thanks for your help