>Now the combined data from table 1 and 2 are not necessarily in table 3 thus needs to seek in table four.
>
>I hope this is clear enough...i am boggled. I am trying to do a SQL with a join, but I am not sure that I am getting it right. Thanks in adavnce.

The structure of the tables would be useful to know (fieldnames) and then we can discuss how they should be joined together to get the results you want.