[thelist] Query Quandry

[Jay Blanchard]

[snip]
Is there a 1-1 correspondence between son and sot?  Having multiple records
for sot for each son (related using the BillingNumber) are going to further
complicate this query.
[/snip]

I have discovered that for each son. there is one sot. BillDate and
BillingNumber are the only commonalities which can be related between
tables. Since there is one of each in each table there needs be no GROUP BY,
or SUM for that matter. Methinks I should go with a sub-query.

Thanks!

Jay