Is there a way to create an SDE view using a FC and a table, where for each record in the FC there are 0 or several records in the table.
I tried to create a SDE View i arcCatalog 10.2 with a query similar to this one:
select FC.Code, Table.DateEvent from FC, Table where FC.Code = Table.Code
and when I add the SDE view in ArcMap it asks for an field that is a unique ID, otherwise the SDe View can not be shown.
How can I create a field that is an unique id.