I was following along in the tutorial "Data Virtualization Basics -> Advanced Operations -> Create a join view between heterogeneous sources". After creating the "client_with_bills" view, and executing the query, I get an error that states "Column 'client_id' in order clause is ambiguous". I removed the client_id from the output (as directed). Any information on why this fails? I don't have any order by fields selected, and client_id does not even show up in that list. The individual views work fine separately (personal_data_crm and billing_information). Below is the exact error output:
Error executing query. Total time 0.029 seconds.
CLIENT_WITH_BILLS [PROJECTION] [ERROR]
CLIENT_WITH_BILLS [JOIN] [ERROR]
PERSONAL_DATA_CRM [VIRTUAL] [ERROR]
Column 'client_id' in order clause is ambiguous
Total rows received: 0 (shown 0)