Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m sad

Cannot create view to join two Column Subset

Using column subsets on the Opportunity object. But when I try to create Opportunity view:

Create View Opportunity as
select A.*, B.*
from Opportunity_ColumnSubsetAP A, Opportunity_ColumnSubsetQZ b
where A.id = b.id

I get error: Column names in each view or function must be unique. Column name 'Id' in view or function 'Opportunity' is specified more than once.

Is there a quick fix for creating the view. Or do I have to explicitly define the columns I want to select from my subset?
1 person has
this problem
+1
Reply