Assuming I could use the aggregate of any variable with numbers, say A.variable1, what would be the modification to the code below? I've tried putting a MAX in for...

The problem is that only the fields in table A are the same for each record. Fields in table B are different for each record, so running DISTINCT still...