I have the following tables.
Vendors - V
Items - I
Vendor Items (Which has a combination of Item and Vendor as its primary key) - VI
VI has a comment field with numeric values - COMMENT_1
I want to get all records from V along with the greatest COMMENT_1 in VI where V.VENDOR = VI.VENDOR
Thanks in advance. I hope my question is clear.