I have been joined one table to pull one extra column for existing query., But after I added that table results were getting duploicates. When I checked on it found that there is multiple rows for few Items but we need to pull only the date inserted recently which means it has column "RowUpdatedateTime" , need to get max of
this date.... So I am not sure how can I pull this...
This is the way I am joining my table called ItemFaciVendors
LEFT OUTER JOIN ItemFaciVendors IFV
ON IIS.ItemNumber = IFV.CatalogNumber
and I am pulling IFV.VendorNumber in select list...
But I need to restrict duplicates by getting only IFV.RowUpdatedateTime is higher date.
Can you please suggest how can I achieve this?