I only need to return the one for the distinct combination.

That statement was what I need. I did need to select a distinct customer name and the item description was based on a alphabetical list.

So all I had to do...

There is a product on the market called DataMirror. I have worked with this some at a job where DB2 info in the I series was replicated to a SQL...