create table student_A(
id number not null,
name varchar2(50),
lastname varchar2(50));
create unique index intstd_A on student (id);
create table student_B(
id number not null,
name varchar2(50),
lastname varchar2(50));
create unique index intstd_A on student_B (id , lastname );
What would be the query to compare this two?