This might be more of a math problem than a Caché question.
I have a SQL query that joins two tables. I want to assign a unique ID to each row of the product table.
InterSystems Caché is a multi-model DBMS and application server. See more details here.