If i want to print the common point or interaction point bewteen 2 tables using inner join or other method, it is showing error , why i m not able to print common point which i m using eg if i m writing this

#1

select id , name , roll_no , class , section , subject_code, mark from student INNER JOIN mark ON student.id = mark.id;
then it shows error as
Column ‘id’ in field list is ambiguous

#2

Hello @coding123c,
This means two columns have the same column name that is id. So either do not slect id or you can change the name of column id in student table and can compare using that name to join. student.newid=mark,id like this if you give new name newid.

#3

I hope I’ve cleared your doubt. I ask you to please rate your experience here
Your feedback is very important. It helps us improve our platform and hence provide you
the learning experience you deserve.

On the off chance, you still have some questions or not find the answers satisfactory, you may reopen
the doubt.