Joining 2 tables

[raghuvr33]

I need to join two tables getting only the latest record from second table which has multiple records matching with first table. Below is the data for the two tables and data needed for the final table.

Table A:

A1 B1 C1

Table B:

A1 B1 C1 D1

A1 B1 C1 D2

A1 B1 C1 D3

Final Table:

A1 B1 C1 D3

The data in the final table should be 1 row having four columns with the latest data  D3  in table B.

How would we go about doing this in QV?

[raghuvr33]

The max is not commented in my actual script. Was trying something when i copied above

[maxgro · Accepted solution]

this works

load a,b,c,d,e,

max(...), min(...)

resident ...

group by a,b,c,d,e;

this doesn't work

load a,b,c,d,e,

max(...), min(...)

resident ...

group by a,b,c;          // fields not in max, min, ..... need group by

[raghuvr33]

This worked without giving error when i included all the fields in the group by statement.

Thanks for your help!!