select all the data from both the table emp no,emp name and dept no ,dept name.
Answers
Answered by
1
frnd u have not posted the pic or diagram.
post that table.
post that table.
Prajwalparikshith:
ok
create table dept( deep no (2,0), dname varchar 2(14), lot varchar 2(13), constraints pk_dept primary key (dept no))
create table emp( emp no number (4,0), name varchar2(10), job varchar2(9), mgr number (4,0), hirdate date, say number (7,2), comm number (7,2), deptno number (2,0), constraint pk_emp primary key (empno), constraint fk_deptno foreign key (deptno) references dept (deptno))
Similar questions