MS Access Query (two tables only)
I have two tables:
**T1**
ID |Transaction| amount |
1 |trans1 | 97 |
1 |trans2 | 22 |
2 |trans7 | 98 |
**T2**
ID |description|spec|
1 |Item 1 |text|
2 |Item 2 |zip |
Note: ID columns in both tables are THE SAME. However, ID in table T1 is
not unique.
I need query to retrieve data from tables but only row with highest amount
(table T1). Example result:
ID|description|spec|transaction|amount|
1 |item1 |text| trans2 | 97 |
1 |item2 |zip | trans7 | 98 |
Please help!
Thank you.
No comments:
Post a Comment