You should extend the query of Jens like this
Table1 inner join Table2
But you should also learn more TSQL, because this is all very basic.
"RP" <com> wrote in message
Hi Jens Süßmeyer
The Table1 and table2 are really resultsets which are
used to create the final resultset. This resultset is
used to create a report.. There are no PK's defined. What
you mentioned is correct, I will get the combinations. I
may have to find another way to accomplish that result..