Column Ambiguously Defined - No Line / Column Number

Column Ambiguously Defined - No Line / Column Number

I've been trying to create a query that joins two sets of tables together using several columns. I have tried assigning aliases to each column but I am still receiving a&nbsp;<strong>(ORA-00918: column ambiguously defined)</strong>&nbsp;error with no line number / direction on which column oracle has an issue with. Can someone please help me? Been stuck on this issue for hours now. My code is below, thanks in advance!

I've been trying to create a query that joins two sets of tables together using several columns. I have tried assigning aliases to each column but I am still receiving a (ORA-00918: column ambiguously defined) error with no line number / direction on which column oracle has an issue with. Can someone please help me? Been stuck on this issue for hours now. My code is below, thanks in advance!

 SELECT *
 FROM
 (select v.value_id as i_value_id
 , v.value_nb as i_value_nb
 , v.utc_offset as i_utc_offset
 , v.data_Date as i_data_date
 , v.hr_utc as i_hr_utc
 , v.utc_offset as i_utc_offset
 , v.hr as i_hr
 , v.hr_num as i_hr_num
 , v.data_Code as i_data_code
 , v.Code as i_code
 , ff.form_Field_tx as i_form_field_tx
 , sv.submission_value_id as i_submission_value_id
 , s.submission_name_tx as i_submission_name_tx
 , s.submission_id as i_submission_id
 , fl.form_line_tx as i_form_line_tx
 , fs.form_section_tx as i_form_section_tx
 , sf.form_name_tx as i_form_name_tx
 , sf.form_label_tx as i_form_label_tx
 , sf.form_number_tx as i_form_number_tx
 , sf.survey_id as i_survey_id
   from value v
   join sub_value sv on v.value_id = sv.value_id
   join form_Field ff on sv.form_Field_id = ff.form_Field_id
   join sub s on sv.submission_id = s.submission_id
   LEFT OUTER JOIN form_line fl ON ff.form_line_id = fl.form_line_id
   LEFT OUTER JOIN form_section fs ON fl.form_section_id = fs.form_section_id
   LEFT OUTER JOIN survey_form sf ON fs.survey_form_id = sf.survey_form_id) subq1
   JOIN
   (select va.value_id as o_value_Id
   , va.value_nb as o_value_nb
   , va.utc_offset as o_utc_offset
   , va.data_Date as o_data_date
   , va.hr_utc as o_hr_utc
   , va.hr as o_hr
   , va.hr_num as o_hr_num


Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

An Introduction to Oracle SQL

An Introduction to Oracle SQL: A quick tour of the six principal clauses of the SELECT statement.

What are the differences between Standard SQL and Transact-SQL?

In this article, we'll explain syntax differences between standard SQL and the Transact-SQL language dedicated to interacting with the SQL

SQL Server Tutorial For Beginners - Learn MS SQL Server with Examples

SQL Server Tutorial For Beginners, Microsoft SQL Server Tutorial, SQL Server Training. Microsoft SQL Server explains all the fundamentals of MS SQL Server with examples. What is DBMS? What is SQL? What is SQL Server? SQL Server Installation