[thelist] Query Quandry

Jay Blanchard jay.blanchard at niicommunications.com
Thu Apr 4 14:35:02 CST 2002

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.

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.



More information about the thelist mailing list